rollforward issue

[Former Member]

Hi All,

We are on client refresh process so far we completed restore process till now but when i try to do the rollforward i got below error...

IMU-IQB:db2gqb 13> db2 rollforward db GQB to end of logs

SQL4970N Roll-forward recovery on database "GQB" cannot reach the specified

stop point (end-of-log or point-in-time) because of missing or corrupted log

file(s) on database partition(s) "0". Roll-forward recovery processing has

halted on log file "S0110861.LOG".

Appreciated your help on this..

Panu

[paul_power]

Dear Panu,

The rollforward seems to fail as it cannot find the required log file

S0110861.LOG

does this log file exist and can it be made available to the db for rollforward ?

If it has been lost or is corrupt, then you will only be able to rollforward to the closest existing, usable log file

e.g. S0110860.LOG and then stop the rollforward to bring the db online.

Regards,

Paul