REPAIR-DBD—Sync the DBD with the Db2 Catalog

The REPAIR-DBD keyword specifies whether to update the DBD to synchronize it with the Db2 catalog.
cafrdb2
The REPAIR-DBD keyword specifies whether to update the DBD to synchronize it with the Db2 catalog. During a point-in-time recovery in which an object changes from RRF (Reordered Row Format) to BRF (Basic Row Format) or from BRF to RRF, failing to update the DBD leaves the catalog (specifically, the SYSTABLEPART FORMAT entry) out of sync with the DBD entry for the RRF or BRF entry.
REPAIR-DBD is not valid with RECOVER INDEX and REBUILD INDEX.
This keyword has the following format:
REPAIR-DBD [
YES
|NO]
  • YES
    Updates the DBD when necessary to synchronize it with the Db2 catalog. This value is the default. This setting can affect access to other objects in the database of the recovered tablespace when the database goes through the following steps:
    1. START DATABASE ACCESS (UT)
    2. REPAIR OBJECT LOG YES DBD REBUILD DATABASE
    3. START DATABASE ACCESS (RW)
  • NO
    Does not update the DBD. This setting can leave the DBD out of sync with the Db2 catalog, specifically, with the FORMAT field of SYSTABLEPART.