PH00296: REORG OR TRANSACTION ABENDS04E RC00C90101 DUE TO ZERO OR BAD INDEX PAGES. 18/07/16 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Buffer manager did not write out some index pages to shadow
  index during REORG which caused following abends.
  
  ABENDS04E RC00C90101 DSNKTRAV:500C
  ABENDS04E RC00C90101 DSNKNXT2:5004
  ABENDS04E RC00C90101 DSNIOST2:2010
  
  DSN1990I DSN1CPIP BROKEN PAGE. PAGE NUMBER = 0000F1F2. REASON:
  NUMBER OF KEYS INVALID.
  SERVICE INFO: CODE= 'D5A'X  IPNKEYS=0
                                                                 .
  Additional keywords: abend04e
                       dsnktrav erqual500c
                       dsnknxt2 erqual5004
                       dsniost2 erqual2010
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Db2 for z/OS V11 and V12 users, with PI88894 *
  *                 applied.  PI88894 is part of PTFs UI52481,   *
  *                 UI52945, and UI55254 in V11, and PTFs        *
  *                 UI52480, UI52944, and UI53695 in V12.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Lost updates to table spaces or         *
  *                      indexes.                                *
  *                                                              *
  *                      Corrupted data can result in any of     *
  *                      the following symptoms:                 *
  *                       - Incorrect output, INCORROUT.         *
  *                       - ABEND04E RC00C90101, RC00C90102,     *
  *                         RC00C90105, or RC00C902xx in         *
  *                         various CSECTs.                      *
  *                       - Data/index inconsistencies reported  *
  *                         by the CHECK INDEX utility.          *
  *                       - Page regression reported by the      *
  *                         DSN1LOGP utility.                    *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  A small timing window exists between a DASD write engine trying
  to force out a page, and an SQL or utility updater holding a
  latch on the page.  If the write engine cannot write the page
  because of the held latch, it marks it for a synchronous write
  to be done when the latch is released.  However, it may be that
  the latch has already been released by the time the page is
  thus marked.  PI88894 introduced a code change where a page in
  that situation will not be chosen for write, and will not be
  written even if the table space or index is closed.  This
  results in page regression.
  

Problem conclusion

• The DASD write engine code has been modified to no longer skip
  over a page flagged for a synchronous write.
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UI57626 UI57628

Modules/Macros

•    DSNB5COM
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI57628

     UP18/08/16 P F808 «

• RC10 PSY UI57626

     UP18/08/16 P F808 «

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.