Recovery of the catalog and directory

Catalog and directory objects must be recovered in a particular order.

For some catalog and directory objects the order differs, depending on whether objects were dropped or deleted, and new objects created.

Sometimes the recovery of some catalog and directory objects depends on information that is derived from other catalog and directory objects. You must recover some of these objects in separate RECOVER utility control statements.

However, you can use the same RECOVER control statement to recover a catalog or directory table space along with its corresponding IBM®-defined indexes. After these logically dependent objects are restored to an undamaged state, you can recover the remaining catalog and directory objects in a single RECOVER utility control statement. These restrictions apply regardless of the type of recovery that you perform on the catalog.

You can use the REPORT utility to report on recovery information about the catalog and directory.

To avoid restart processing of any page sets before attempts are made to recover any of the members of the list of catalog and directory objects, you must set subsystem parameters DEFER and ALL. You can do this by setting the values DEFER in field 1 and ALL in field 2 of installation panel DSNTIPS.

Important: Recovering the Db2 catalog and directory to a prior point in time is strongly discouraged.