Saturday, April 5, 2008

REDIRECTED RESTORE ISSUE

If you are restoring into a different alias using into clause, you should use the original database name in db2 restore continue statement.If you use the alias you will recieve the error:DB21080E No previous RESTORE DATABASE command with REDIRECT option was issuedfor this database alias, or the information about that command is lost.Refer to the following example.

EXAMPLE SCRIPT:

db2 restore db sample to /db2kk/db2inst1/SAMPLE1 into SAMPLE1 redirect without prompting;

db2 "set tablespace containers for 5 using (PATH "/db2kk/db2inst1/sample1")";

db2 restore db SAMPLE continue;

db2 rollforward db SAMPLE1 to end of logs and complete;

1 comment:

Tara Prasad Dash said...

I am struck with a problem... i want to retrieve a specific number of rows from a table say, rows between 20th and 47th row. is there any thing to do that in DB2.

i have posted a query in this forum here http://www.dbforums.com/forumdisplay.php?f=8

Can you help me?

regards,