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

Obtain the fix for this APAR.

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