PI47212: END UNDO/REDO/TODO RECORDS ARE NOT RECOGNIZED AFTER A DB2 OUTAGE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 V11 changed the offset and length of URIDs stored in END
  UNDO/REDO/TODO records.  IIDR CDC for z/OS does not account for
  this, and so is unable to recognize any of these records when
  they are written after a DB2 RESTART.  This can leave a UR
  hanging in the Staging Space.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IIDR CDC for z/OS who experience a  *
  *                 DB2 outage.                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: After a DB2 outage, incomplete Units of *
  *                      Recovery (URs) will be disposed of by   *
  *                      DB2 when DB2 is restarted by writing    *
  *                      END UNDO/TODO/REDO records to the log.  *
  *                      With DB2 V11, the location within these *
  *                      records of the URID for the UR being    *
  *                      disposed of has changed.  IIDR CDC for  *
  *                      z/OS is not accessing the URID in its   *
  *                      new position, so it never finds that    *
  *                      the UR has been completed.  Such URs    *
  *                      will remain in the Staging Space        *
  *                      indefinitely, until some action is      *
  *                      taken to remove them.                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  
  URs terminated by DB2 after an outage may remain in the Staging
  Space indefinitely.
  

Problem conclusion

• Logic has been adjusted to access the URID in the proper
  location of DB2 V11 END UNDO/TODO/REDO log records.
  

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:

  UI31571

Modules/Macros

•    CHCDXLDL
  

Fix information

• Fixed component name

  INFO SRVR CDC Z

• Fixed component ID

  5655U7600

Applicable component levels

• RA21 PSY UI31571

     UP15/10/06 P F510

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.