PM84298: COMPRESSION DICTIONARY MISSING

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• InfoSphere Replication Server (Q-Capture for DB2) product
  received RC00C90063 for an unavailable dictionary after
  migrating to Version 10 NFM.
  
  A non-compressed partition of a table space was altered to
  COMPRESS YES.  A REORG was run on the partition, specifying
  KEEPDICTIONARY.  REORG recognized there was no dictionary and
  began to build one for the shadows.  At the same time that REORG
  was running, inserts were taking place. When there was
  sufficient data to build a dictionary, the COMPRESS ON
  INSERT function built a dictionary.  REORG failed to allow for
  the dictionary built by the INSERTS.
  

Local fix

• Use SHRLEVEL REFERENCE to run REORG
  OR
  Do not specify KEEPDICTIONARY
  OR
  Wait for INSERT processing to build a dictionary before
  submitting REORG
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 for z/OS and DB2 10 for z/OS       *
  *                 utility users of REORG SHRLEVEL CHANGE       *
  *                 KEEPDICTIONARY of a DATA CAPTURE CHANGES     *
  *                 table space                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Following a REORG TABLESPACE SHRLEVEL   *
  *                      CHANGE KEEPDICTIONARY, a data capture   *
  *                      program abended with an ABENDS0C7 RC0   *
  *                      at DSNIDCML +x'1CD0' followed by an     *
  *                      ABEND04E RC00C90007 at DSNIDCML+x'3AFE' *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  A non-empty partition of a table space defined with DATA CAPTURE
  CHANGES and COMPRESS NO, was changed to COMPRESS YES with an
  ALTER TABLESPACE ALTER PARTITION.  A REORG TABLESPACE PART n
  SHRLEVEL CHANGE KEEPDICTIONARY was run on that partition which
  built a dictionary for it.  However, because REORG was specified
  with KEEPDICTIONARY, REORG did not update the new dictionary
  with the current RBA (or LRSN for data sharing).  While the
  REORG was running, INSERTS were also being done which were
  also creating a dictionary for those rows being inserted along
  with log records for the insertions.
  
  DB2 then decided that the dictionary created for the INSERTs
  could be deleted.  When the data capture program was run, it
  tried to use the REORG-built dictionary to decompress an INSERT
  log record but abended with ABEND0C7 RC0 at DSNIDCML OFFSET1CD0.
  This was followed by an ABEND04E RC00C90007 at DSNIDCML
  OFFSET3AFE.
  

Problem conclusion

• REORG code has been changed to set the current RBA or LRSN value
  in any dictionary it creates for a DATA CAPTURE CHANGES table
  space.
  

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:

  UK92889 UK92890

Modules/Macros

• DSNURSWD
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK92889

     UP13/04/10 P F304

• R910 PSY UK92890

     UP13/04/10 P F304

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.