RE: DB2EUG: Restore database to new

[Sireesh Chandra M, STC Chennai]

Title: Restore database to new

Hi All,

      Thanks for all those who responded. The database backup location gave me problems. All throughout I gave the full backup location but later i found out from listserv mails that only the topmost location needs to be given avoiding the other subdirectories which db2 creates automatically.

 

Thanks Again

Sireesh.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 11:10 PM
To: [EMAIL PROTECTED]
Subject: RE: DB2EUG: Restore database to new

I did the following:

1. Created again a database TEST and used 'RESTORE TO NEW' option and manually giving the backed up location. I got the error message SQL2542N

1)  Drop the test database you created. On creation of this test database you created a new database seed, and DB2 is complaining that the seed numbers do not  match.

 

2) after dropping this database.  From the command line processor enter ? restore.  This will display the restore comand and options.  Run the resotre command with your appropriate options and you will be able to restore with no problems. 

 

for example:

 

db2 => ? restore
RESTORE DATABASE source-database-alias { restore-options | CONTINUE | ABORT }

 

restore-options:
  [USER username [USING password]]
  [{TABLESPACE ONLINE |
    TABLESPACE (tblspace-name [ {,tblspace-name} ... ]) [ONLINE] |
    HISTORY FILE [ONLINE]}] [{USE ADSM
  [OPEN num-sess SESSIONS] | FROM dir/dev [ {,dir/dev} ... ] | LOAD shared-lib
  [OPEN num-sess SESSIONS]}] [TAKEN AT date-time] [TO target-directory]
  [INTO target-database-alias] [NEWLOGPATH directory]
  [WITH num-buff BUFFERS] [BUFFER buffer-size]
  [DLREPORT file-name] [REPLACE EXISTING] [REDIRECT] [PARALLELISM n]
  [WITHOUT ROLLING FORWARD] [WITHOUT DATALINK] [WITHOUT PROMPTING]

enter:  restore db test user ..... from  x:  to  d:  into test without prompting

 

use whatever options are applicable.

 

 

-regards,

 

Rakesh 

 

 

 

 

 

 -----Original Message-----
From: Sireesh Chandra M, STC Chennai [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 9:04 AM
To: [EMAIL PROTECTED]
Subject: DB2EUG: Restore database to new

Hi DBA's,
        I am using DB2 UDB V6.1 on Windows NT 4.0 SP6a. I have a couple of databases to be dropped but i may need them in future. So I took a full offline backup of a database TEST and then dropped it. Now if I need to restore the database from the backup, how should i proceed??

I did the following:

1. Created again a database TEST and used 'RESTORE TO NEW' option and manually giving the backed up location. I got the error message SQL2542N.

2. I selected 'Restore' option and gave the information manually and still the same error message SQL2542N.

3. Used the option 'Create database from backup' and its not taking the alias saying that 'Alias "" is invalid' even though i gave a new alias name.

Can anyone throw light on how this problem can be dealt with. Only when I am able to restore the test database i can confidently proceed in dropping the other databases.

TIA
Sireesh.