SQLDBDIR lost, recovery-scenarios

[Frederick Page]

Hi everybody,

we're using DB2 7.2 FP 11 on WinNT machines, today one server was down,
because the complete directory E:\DB2\NODE0000 \SQLDBDIR was gone.

Question: I restored this directory from a TSM-backup, but could I
have done something else?

After the restore most databases worked again, with the exception of
one: "SQL5005C" (System error). I had to restore the database from a
2 day old backup. Although I previously saved the logfiles, I was not
able to rollforward this database (SQL1206N).

I was under the impression, that I would be able to restore a database
to a specific point in time, if I had the correct logfiles.

Question: if I have all logfiles since the last "backup database", how
do I roll it forward?

TIA Frederick

[Kelly D. Rodger]

Frederick, I'm puzzled by that SQL1206 - "PRUNE LOGFILE is not supported
in this configuration". What command did you issue after the RESTORE
completed?

Also, I assume that this is an offline backup image of a recoverable
(LOGRETAIN or USEREXIT = ON) database, true?

The easy answer to your question is that you simply issue the
ROLLFORWARD command after the RESTORE completes, but we probably need to
understand more about your scenario first. Do you recall the exact
RESTORE command that you issued?

Thanks.
kdr
Frederick Page wrote:

After the restore most databases worked again, with the exception of
one: "SQL5005C" (System error). I had to restore the database from a
2 day old backup. Although I previously saved the logfiles, I was not
able to rollforward this database (SQL1206N).

I was under the impression, that I would be able to restore a database
to a specific point in time, if I had the correct logfiles.

Question: if I have all logfiles since the last "backup database", how
do I roll it forward?

--
=============== =============== =============== =============== =========
Kelly D. Rodger IBM Canada
DB2 UDB Development Backup & Restore
=============== =============== =============== =============== =========