By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,649 Members | 2,142 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,649 IT Pros & Developers. It's quick & easy.

Help withDB2 Recover Command

P: n/a
I have been testing the db2 recover command on a DB2 V8.2 Linux
database. The database contains a single partition. I am not
archiving logs but retaining them on disk. the backup image is to
disk as well. I performed the following in order :

1. OFFLINE BACKUP <time#1>
2. Create table S.T (c1 smallint)
3. Insert several rows into S.T - values 1,2,3,4,5
4. ONLINE BACKUP <time#2>
5. Insert several more rows 6,7,8,9
6. Delete rows 1,2
7. ONLINE BACKUP <time#3)

I then tried a few Recovery operations :

1. recover database mydb to <time#2>
- This works OK
2. recover database mydb to <just before time#2>.
- This works OK.
3. recover database mydb to end of logs.
- This seems to roll thru the previous recover commands just issued
4. recover database mydb to <time#3>
- This fails with a SQL1254 : No match for a database image file
was found

Q1. Can anyone explain what is going on with Recovery test 3? Is it
using the logs and sees the previous recovery operations?

Q2. In recovery test #4, why can't I recovery to PIT specified? I can
see the backup image in the directory with the proper timestamp.

May 14 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.