IBM Support

PK91830: ABEND04E-00C90105 DSNKINSL:0D44 09/07/22 PTF PECHANGE

A fix is available

 

APAR status

  • Closed as program error.

Error description

  • Abend S04E RC00C90105 in DSNKINSL:0D44.
    The problem occurs during an index leaf page split and results
    in a broken page because the amount of free space and the free
    space pointer are invalid.
    Additional information 07/22/2009:
    This problem was caused by PK62214/UK39357.
    Additional symptoms: 04E RC00C90101 DSNKISPL ERQUAL53C9 ( 53C9 )
    00C90101

Local fix

  • n/a

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 for z/OS users with PK62214/UK39357 *
    * applied. *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND04E RC00C90105 DSNKINSL ERQUAL0D44 *
    * or *
    * The value for REORGPSEUDODELETES column *
    * in real-time statistics (RTS) table is *
    * greater than the actual number of *
    * pseudo-deletes since last REORG, *
    * REBUILD, or LOAD REPLACE. *
    ****************************************************************
    * RECOMMENDATION: Apply corrective PTF when available. *
    ****************************************************************
    After applying PK62214 (UK39357) an index page split may cause
    ABEND04E RC00C90105 and/or incorrect values for
    REORGPSEUDODELETES in the real-time statistics (RTS) table
    SYSIBM.SYSINDEXSPACESTATS.

    An incorrect calculation in the asymmetric split algorithm
    occurred when customer reverted from DB2 for z/OS Version 9,
    new function mode (NFM) to DB2 for z/OS Version 9, compatibility
    mode* (CM*). A broken index page occurred when a negative free
    space value was determined.

    The value for REORGPSEUDODELETES column in real-time statistics
    table SYSIBM.SYSINDEXSPACESTATS is greater than the actual
    number of pseudo-deletes since last REORG, REBUILD, or LOAD
    REPLACE. For every index page split, the REORGPSEUDODELETES
    value was incorrectly increased by +1.

Problem conclusion

  • Code has been modified to correctly determine the amount of
    space used on the index page and removed incorrect accumulation
    of REORGPSEUDODELETES during the index page split.

Temporary fix

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

Comments

APAR Information

  • APAR number

    PK91830

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    YesPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-07-20

  • Closed date

    2009-08-26

  • Last modified date

    2010-02-24

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

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

    UK49588

Modules/Macros
DSNKISPL          

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R910 PSY UK49588

       UP09/09/10 P F909 ®

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: 910

Reference #: PK91830

Modified date: 24 February 2010


Translate this page: