I am working with db2v7 and aix 4.3.3 .
I am going to restore from online backup that has been taken on july 29 , how can I found out which logs file I should use for rollforwarding and what is the sql command for rollforwarding.
thank you in advance for your help.
db2 list history backup since 20040709 for database <dbname>
The output will show the 'first log file' you will need ....
Then you'll have to get all the logs since then for the rollforward to succeed ...
For the command, have a look in the command reference or google for 'db2 rollforward database'
Here's an example
rollforward database sample to end of logs and complete
let me I explaine more detail the senerio is
1-I update tab1 set col1= xx and created table xx
2- I took online backup timestamp = xxxxxxxxxx
1- I update tab1 set col2= YY and created table YY
2- I took online backup timestamp = YYYYYYYYYYY
1- I update tab1 set col3= ZZ and created table ZZ
2- I took online backup timestamp = ZZZZZZZZZZZZ
I did ftp backp image YYYYYYYYYY and log file to another box and restored to database
as you told me when I rollforwarded form S000000004.LOG (I retrevied form history) by the end of log S00000009.log I have all updated from step 3!!!!!!
I do not want that I need just updated to end of step2.
Please help. thanks