Recovering after a conditional restart of Db2

After a Db2 conditional restart in which a log record range is specified, a portion of the Db2 recovery log is no longer available.

About this task

If the unavailable portion includes information that is needed for internal Db2 processing, an attempt to use the RECOVER utility to restore directory table spaces DSNDBD01 or SYSUTILX, or catalog table space SYSTSCPY fails with ABEND04E RC00E40119.

Procedure

Instead of using the RECOVER utility, use the following procedure to recover those table spaces and their indexes:

  1. Run DSN1COPY to restore the table spaces from an image copy.
  2. Run the RECOVER utility with the LOGONLY option to apply updates from the log records to the recovered table spaces.
  3. Rebuild the indexes.
  4. Make a full image copy of the table spaces, and optionally the indexes, to make the table spaces and indexes recoverable.