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;
Saturday, April 5, 2008
Subscribe to:
Post Comments (Atom)
1 comment:
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,
Post a Comment