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

HTH

Sathyaram

Hi Sathyaram,
let me I explaine more detail the senerio is

step1 :
1-I update tab1 set col1= xx and created table xx
2- I took online backup timestamp = xxxxxxxxxx
step2 :
1- I update tab1 set col2= YY and created table YY
2- I took online backup timestamp = YYYYYYYYYYY
step3 :
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

Then you need to do point in time recovery ...

ROLLFORWARD DATABASE dbname to <iso-time> and complete

The iso time should be atleast the 'end-time' of the backup in step2 ...

HTH

Sathyaram

Thank you so much for your help Sathyaram