Db2 7.1 FP10

I am using an online backup to restore a live database onto a development machine. The restore has been sucessfull, but I am having problems with the roll forward.

Because an online backup was used, log files were not captured. I have copied ALL log files in the production dir to my development server.

"rollforward db JDS_LIVE stop" results in the following error:

Database "JDS_LIVE" cannot be brought out of roll forward pending state until roll-forward has passed a point in time greater than or equal to "2004-03-31-04.32.53.000000", because node "0" contains information later than the specified time

My online backup has a time stamp of 20040330230004

Obviously coming from a production server, I have logfiles dated before and after both of the quoted date/times. I have tried many combinations of log files before / after both dates, but get the same error.

The log files from what date range should I be including in the rollforward ..... Or am I doing something else wrong

Cam

On the production machine, do a "LIST HISTORY BACKUP ALL FOR <dbname>".

That will tell you what log files are needed (Earliest-Current).

My appologies ... I am learning as I go here

I have done the list history command as you instruct. Under the entry matching the Online backup I am using I see the files identified as:
Earliest: S0000259.log
Current: S0000261.log

I have copied the 3 files 259,260 and 261 to the log directory on the test machine (no other log files there). I reran the same statement and received the same error message as before.

Is it just the files from this particular online backup I need to worry about, or anything before or after it. ? Is it all files since the last Offline backup ??

Cam

No, those should be enough to get it consistent.

Is this what you're issuing?
ROLLFORWARD DATABASE <dbname> TO END OF LOGS AND STOP

If so, try add OVERFLOW LOG PATH pointing to the directory where the logs are, maybe there's some mix-up there.

It has completed sucessfully !!

I was using:
rollforward db JDS_LIVE stop

As per your message I tried again using:
rollforward db JDS_LIVE to end of logs and stop

That seemed to do the trick

Thanks !!

Oops, I should have caught that from the start...