Hello, I need your help

How many logs I need for rollfordward database?

I execute rollforward an proccess 87 logs, but I didn't have the next log!!!! S000400.LOG

Could you help me please?

At a minimum you will need the logs that were active during the online backup. But the exact number of logs needed depends on whether you roll forward to:

1. end of logs,
2. a specific time, or
3. minimum roll forward time (END OF BACKUP).

You can also try the NORETRIEVE option, which sometimes limits the number of logs that will be required.

Thaks Marcus A,

I execute db2 "rollforward db <db name> to end of logs and stop overflow log path (<dir where you copied the logs>) noretrieve"

Then... I will need the logs that were active during the online backup?
but....I had a backup from 20080514, and my last log 20080516!!!, I will try one more time with other backup that I have more LOGS...7 days.

What do yo thing?

Do you need to rollforward to end of logs, or do you just need to restore the backup and rollforward the logs to the end of backup? If the later is true (and you have DB2 9.5+) then rollforward to END OF BACKUP.

If you don't have a DB2 version that supports END OF BACKUP option, then rollforward to 2000-01-01.01.01.01.000000 and DB2 will give you an error telling you the minimum rollforward time, and then resubmit the rollforward with the minimum rollforward time that DB2 tells you.

I only need connecto to my db
I just need execute rollfordwar to any time...only finish and connect

I will try with your advice

What do you thing?
What is the correct command?

Rollforward to END OF BACKUP AND STOP as described above.

ohhh no, my version don't accept to end of backup, I have 8.2 version.

I will try with end of logs again, but now I have more LOGS.

Thaks Marcus...I will tell you when finish.
Maybe I will need your help again.

I gave you the alternative to use if you can't use END OF BACKUP. Read my post above.

I tried whit your other suggestion, but when I execute rollforward to <date>, return me that other parameter was espected.

what problems could I have with end of logs? I hava more LOGS.
attempt to reach the current date?

When give me the error, that the last logs not found I can try with other parameters?
Coul yo give the correct sintax?

thank

Marcus Thanks for your help
I appreciate it!!!

I restored my db.
If you need anything and if I can help you, only ask.