IBM Support

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

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PH00296

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    YesPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-07-10

  • Closed date

    2018-08-01

  • Last modified date

    2018-09-04

  • 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.



Document information

More support for: DB2 for z/OS

Software version: 11.0

Reference #: PH00296

Modified date: 04 September 2018


Translate this page: