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

[Former Member]

Kumar -

First of all I would find where you have all the logfiles located that you will be using for the rollforward. They may be in a different path that what you are expecting. Once you know the path, then use the overflow log path option to the rollforward and complete command.

rollforward db gqb to end of logs overflow log path ( /path/to/your/log/files )

db2 rollforward db gqb complete overflow log path ( /path/to/your/log/files )

Andrew