Database exception table records

Database exception table (DBET) log records register different types of information: exception states and image copies of special table spaces.

Begin program-specific programming interface information.DBET log records also register exception information that is not related to units of recovery.

Exception states

DBET log records register whether any database, table space, index space, or partition is in an exception state. To list all objects in a database that are in an exception state, use the command DISPLAY DATABASE (database name) RESTRICT.

Image copies of special table spaces

Image copies of the following objects are registered in the DBET log record rather than in SYSCOPY. During recovery, they are recovered from the log, and then image copies of other table spaces are located from the recovered SYSCOPY.

  • DSNDB01.SYSUTILX
  • Start of changeFL 509 DSNDB01.SYSTSUTMEnd of change
  • Start of changeFL 509 DSNDB01.SYSTSUTXEnd of change
  • DSNDB01.DBD01
  • DSNDB06.SYSTSCPY
  • DSNDB01.SYSDBDXA

Start of change , , , and are registered in the DBET log record rather than in SYSCOPY. During recovery, they are recovered from the log, and then image copies of other table spaces are located from the recovered SYSCOPY.End program-specific programming interface information.End of change