Hello friends,

In restoring process when i rollforward the db by using

"""db2 rollforward db XPRDBB to end of logs"""

i got the following error message:

"SQL4970N Roll-forward requery on database "XPRDBB" cannot reach the specified. stop point (end-of-log 'or' point-in-time) because of missing log file(s) on node(s) 0."

can any post how to solve this plz...

thanks & regards

it means that the log files, needed for rollforward are not present/accessible
check log directory / archive log directory or tsm

Alternatively, do not roll forward to the end of the logs or do not roll forward at all. The consequence will be, however, that you will not have the latest version of your data.