There is a full backup at Sunday, and at Monday 13:00, the log S0000100.log is saved to TSM. At Monday 14:00, database is crashed.

Then DBA-1 restored the full backup of Sunday, and all archived logs till to S0000100.log to local hard disk (S0000101.log cannot be restored due to TSM issue).

DBA-1 used “roll forward to end of logs and complete”, the database is up, the roll forward type is “end of logs”, but the data between 13:00 and 14:00 is lost.


Now, DBA-2 want to know whether DBA-1 skipped any Logs during restore. How he can find ?

[ NOTE : In history file it will give end of logs only ]

logfiles can NOT be skipped
all available logfiles will be restored upto the point that is possible and which logfiles are available.
best regards, Guy

In the "List History rollforward" have you checked the Earliest Log and Current Log columns? Sorry, if you have already done it. I do not have access to DB2 to check it.

What is the rollforward command used? Did the command use alternate log path option?

As Guy says, it is not possible to skip logs files. You can ignore some after a Point In Time.

HTH

Sathyaram