DSNJ397I csect-name CDDS NEEDS TO BE REDEFINED AND INITIALIZED DUE TO DB2 CONDITIONAL RESTART
Explanation
When the value of subsystem parameter CDDS_MODE is SOURCE_ONLY, after a conditional restart where ENDLRSN, ENDRBA, SYSPITRT, or SYSPITR has been specified as a log truncation point, and the value is not X'FFFFFFFFFFFFFFFFFFFF', 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. The CDDS needs to be redefined.
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
- Issue the -STOP CDDS command to direct the stand-alone subsystem or all members of the data sharing group to close and deallocate the CDDS.
- Delete and redefine the CDDS.
- Issue the -START CDDS command to direct the stand-alone subsystem or all members of the data sharing group to allocate and open the CDDS.
- 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.
- Stop and restart each Db2 subsystem or data sharing member to remove access maintenance mode.
- Follow the steps in the previous paragraph.
