Can't Roll Forward !!! <HELP> (SQL4970N & SQL1274N )

[John Colino]

HELP! I'm stuck. Every week, I would make a backup of our database
using the backup wizard to schedule it. I would also back up the whole
system on ADSM weekly. I used "Create/Database from backup" in the
Control Center to re-create the database on a new machine after our
old harddrive died. The backup was copied from ADSM to a fresh
directory with the same letter (D).

I restored the log files from ADSM to
D:\DB2\NODE0000\SQL00001\SQLLOGDIR

I try the following rollforward commands and get errors! Where should
the log files be? Is there anything else I should be trying?

------------------------------------- Command Entered
------------------------
ROLLFORWARD DATABASE STOCK TO END OF LOGS AND STOP ;
------------------------------------------------------------------------------
SQL4970N Roll-forward recovery on database "STOCK" cannot reach the
specified
stop point (end-of-log or point-in-time) because of missing log
file(s) on
node(s) "0".

------------------------------------- Command Entered
------------------------
ROLLFORWARD DATABASE STOCK TO 2001-05-22-10.00.00 AND STOP ;
------------------------------------------------------------------------------
SQL1274N The database "STOCK" requires roll-forward recovery and the
point-in-time must be to the end of logs.

[jeremy.dodd1]

John,

Try specifying an overflow path for the restore. If you specify where you
have put the logs, this should allow you to complete the rollforward -
assuming you have put enough logs in there to get past the end of the back
up.

Cheers,

jeremy

John Colino <jo...@colino.com> wrote in message
news:9a289a52.01062...@posting.google.com...