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
================================================== ===================