PI93693: DB2 FAILED TO INSERT NEW DICTIONARY INTO CDDS AFTER DSN1COPY+RESET

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1. Object was DSN1COPY+RESET
  2. Dictionary from DSN1COPY was created before BSDS's converted
  to 10 bytes.  so it still used the old 6 bytes field to hold
  the dictionary's version(LRSN)
  3. This dictionary from DSN1COPY was populated to CDDS by REORG
  INITCDDS or REORG KEEPDICTIONARY
  4. On current system, BSDS's been converted to 10 bytes. so all
  new dictionary generated would use the new 10 bytes field to
  hold the dictionary's version(LRSN).
  When above conditions are satisfied,
  As long as the old dictionary from DSN1COPY was populated to
  CDDS, DB2 would fail to insert any new dictionary generated by
  LOAD/REORG.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 11 for z/OS users who use the GDPS   *
  *                 Continuous Availability (Active Active)      *
  *                 solution                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: REORG failed to insert dictionary of a  *
  *                      DSN1COPY'ed page set into the CDDS      *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  User had a Db2 subsystem setup with the GDPS Continuous
  Availability Active Active 2.0 function.  A compressed table
  space with CDC table was DSN1COPYed, converted to extended page
  format, and then restored with the DSN1COPY created prior to
  the extended page format conversion.  A REORG TABLESPACE was
  then run against this object, which completed successfully,
  but it was noticed that the compression dictionary of the
  DSN1COPY-restored page set was never inserted into the
  Compression Dictionary Data Set (CDDS).
  
  This problem was caused by incorrect program logic where REORG
  erroneously determined that the dictionary already exists in
  the CDDS due to the zeroed dictionary timestamp after
  DSN1COPY usage.
  

Problem conclusion

• Code has been modified to correctly compare the dictionary
  timestamp of a DSN1COPY restored page set during LOAD and
  REORG CDDS handling.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI55727

Modules/Macros

•    DSNIDCSF DSNPDLT1 DSNURPDC DSNUZLCR
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI55727

     UP18/05/29 P F805

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.