Start of change

DSNJ396I csect-name CDDS NEEDS TO BE INITIALIZED DUE TO DB2 CONDITIONAL RESTART

Explanation

When the value of subsystem parameter CDDS_MODE is SOURCE_ONLY, during a conditional restart where ENDLRSN, ENDRBA, SYSPITRT, or SYSPITR has been specified as a log truncation point, and the value is not X'FFFFFFFFFFFFFFFFFFFF', Db2 sets the compression dictionary data set (CDDS) to an empty state because the entries in the expansion dictionary that is in the CDDS might no longer match the entries in the corresponding expansion dictionary in the compressed table space that contains the table that is defined with DATA CAPTURE CHANGES.

If IFI READS calls for IFCID 306 require access to the expansion dictionary for a table space, but the table space does not exist in the CDDS, performance might be affected because the expansion dictionary must be read from the table space or the Db2 log data sets.

csect-name
The name of the control section that issued the message.

System action

Db2 restart continues.

User response

After Db2 restart completes for the stand-alone Db2 subsystem or for all members of the data sharing group, run the REORG TABLESPACE utility with the INITCDDS option. That action repopulates the expansion dictionaries in the CDDS for all compressed table spaces with tables that are defined with DATA CAPTURE CHANGES.

If you perform system recovery using the RESTORE SYSTEM utility after a conditional restart for which SYSPITRT or SYSPITR was specified as a log truncation point, after the RESTORE SYSTEM utility has completed:
  1. Stop and restart each Db2 subsystem or data sharing member to remove access maintenance mode.
  2. Follow the instructions in the previous paragraph.
End of change