Faster recovery of catalog and directory objects

In Db2 11, the recovery time of certain catalog and directory objects can be faster because unnecessary log scans are reduced.

The following directory objects and any associated indexes are now recorded in DSNDB01.SYSLGRNX:

  • DSNDB01.SCT02
  • DSNDB01.SPT01
  • DSNDB01.SYSSPUXA
  • DSNDB01.SYSSPUXB

When one of these objects is open for updates, the SYSLGRNX table stores the log range for the update. When these objects must be recovered, Db2 can use the SYSLGRNX records to determine the appropriate log records to read.

Before Db2 11, when these directory objects were not recorded in SYSLGRNX, Db2 could not determine which log records to read and potentially had to scan unnecessary log data. This extra scanning could significantly increase the recovery time of these objects. This increased recovery time also delayed the recovery of the other objects that were included in the same recovery step. (As part of the procedure to recover the catalog and directory, these directory objects are grouped with other objects in the same RECOVER statement.)

This enhancement can improve the recovery time of not only these four directory objects that are now recorded in SYSLGRNX, but of all catalog and directory objects that are recovered in the same recovery step.

The recording of these objects in SYSLGRNX is supported in Db2 11 conversion mode. Db2 can use these SYSLGRNX records for recovery in Db2 11 new-function mode.