IBM Support

PI32991: DSNKINSL:5033 DUE TO MISSING INDEX UPDATE LOG. IT IS POSSIBLE INDEX MANAGER MISSED SETWRITE.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DSNKINSL:5033 due to missing index update log. It is possible
    Index Manager missed SetWrite.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 10 AND DB2 11 for z/OS users using   *
    *                 indexes.                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND04E RC00C90101 DSNKINSL            *
    *                      ERQUAL5033 was encountered              *
    *                      AFTER DB2 RESTART.                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    During LPAR failure testing, an index manager log record
    was not properly written to DASD prior to the failure,
     resulting in the following abend after the subsequent DB2
      restart:
    ABEND04E RC00C90101 DSNKINSL erqual5033
    

Problem conclusion

  • Index manager code was changed to check
    if proper index page latch is held and the index page is marked
    as dirty before a key is inserted into an index leaf page or
    deleted from an index leaf page.
    Following diagnostic abends could be issued when index manager
    code detects missing page latch or page set write error:
    Abend04E RC00C90101 DSNKINSL ERQUAL506E
    Abend04E RC00C90101 DSNKINSL ERQUAL506F
    Abend04E RC00C90101 DSNKDLE  ERQUAL506E
    Abend04E RC00C90101 DSNKDLE  ERQUAL506F
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    PI32991

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-01-19

  • Closed date

    2015-03-12

  • Last modified date

    2015-04-02

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

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

    010PC2Ÿ UI25905 010PC2Ÿ 010PC2Ÿ UI25906 010PC2Ÿ 010PC2Ÿ

Modules/Macros

  •    DSNKDLE  DSNKINSL
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI25905

       UP15/03/28 P F503 Ž

  • RB10 PSY UI25906

       UP15/03/28 P F503 Ž

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
06 May 2020