PI36052: ABEND04E RC00C90101 IN DSNIFDCI ERQUAL 5123 AND MSGDSNJ113E GOT BY QREP AFTER A REORG OF A COMPRESSED TABLESPACE IN DB2 V11 CM

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After a REORG of a compressed tablespace, QREP (Replication
  product) gets the following error:
  DSNJ113E  -DB2S DSNJR003 RBA '00000000000000694000'
  NOT IN ANY ACTIVE OR ARCHIVE LOG DATA SET
  followed by an abend04E RC00c90101 in DSNIFDIC :5123.
  This happens after REORG has inserted an ICTYPE=J record in
  SYSIBM.SYSCOPY which has a truncated PIT_LRSN.
  In the reported case the PIT_LRSN was 000000000000006943FD
  where the RBA in the log was like 6943FDxxxxxx .
  With the incorrect PIT_LRSN in the SYSCOPY ICTYPE=J record,
  when the replication tool comes in with a LRSN of a log record
  to be decompressed, this wrong PIT_LRSN value is used and the
  log read will fail.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 11 for z/OS Conversion Mode (CM)     *
  *                 data sharing users of COMPRESS YES table     *
  *                 spaces that contain tables defined with      *
  *                 DATA CAPTURE CHANGES.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 11 for z/OS Conversion Mode (CM) *
  *                      data sharing, a replication tool was    *
  *                      unable to find a compression dictionary *
  *                      log record when it did exist.           *
  *                                                              *
  *                      MSGDSNJ113E is displayed in this case   *
  *                      and the process abends with ABEND04E    *
  *                      RC00C90101 in DSNIFDCI ERQUAL 5123      *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  When compression dictionaries are written to the DB2 log a
  SYSCOPY row (ICTYPE = 'J') is written that contains RBA and
  LRSN information about the log record written. These SYSCOPY
  PIT_RBA and START_LRSN column values indicate the location
  on the DB2 log where compression dictionaries are found.
  
  The SYSCOPY.PIT_RBA value is usually an LRSN value in data
  sharing but for the SYSCOPY.ICTYPE = 'J' rows it is an RBA
  value.
  
  In DB2 11 for z/OS Conversion Mode (CM) in data sharing the
  RBA values are thought to be LRSNs and this leads to the
  truncation of most of the PIT_RBA values for these ICTYPE = 'J'
  rows in SYSCOPY.
  
  Once these PIT_RBA values are truncated DB2 cannot locate the
  desired compression dictionaries on the DB2 logs.
  
  Additional keywords: DB2MIGV10/K
                       DSNIFDCI ERQUAL5123
  

Problem conclusion

• DB2 code has been changed to properly handle the PIT_RBA values
  in data sharing while a subsystem is in Conversion Mode (CM).
  
  In addition, code has been added so that compression dictionary
  log records can be found for the cases where the PIT_RBA value
  was truncated.
  
  The DB2 11 for z/OS ENFM process has also been updated to ensure
  that SYSCOPY ICTYPE = 'J' log records have their PIT_RBA values
  preserved. If a SYSCOPY.PIT_RBA value is recognized as being
  truncated during ENFM processing then the column value will
  reset to hexadecimal zeroes.
  

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:

  UI26317

Modules/Macros

•    DSNUECML DSNUGCPL DSNUGRDL DSNUPCPY
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI26317

     UP15/04/11 P F504

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.