PI80856: ABEND04E RC00C90101 IN DSNKISPL ERQUAL 5003 WHEN INSERTING INTO A UNIQUE INDEX

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When DB2 deletes and inserts into a unique index in the same
  transaction, if there is SQL with isolation level repeatable
  read running in the system, then DB2 may fail to reserve enough
  space and during thread rollback, ABEND 04E 00C90101 in DSNKISPL
  ERQUAL5003 maybe seen.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 11 for z/OS users using NOT          *
  *                 PADDED unique indexes.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E RC00C90101 in DSNKISPL         *
  *                      ERQUAL5003 happened during thread       *
  *                      rollback                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When inserting into a not padded unique index, there is an
  existing key with same key value as the new key being inserted
  but more blanks. The rid for the existing key is deleted by
  the same transaction which inserts the new key.
  When the insert replaces the existing key with the new key,
  the new key occupies less space on the index leaf page.
  DB2 needs to reserve enough space on the index page for
  the delete to rollback successfully.
  
  When there is SQL reader with isolation level repeatable read
  running in the same system as the insert transaction, the
  insert transaction fails to reserve enough space for the
  delete to rollback in the aforementioned situation.
  Thread rollback fails with ABENC04E RC00C90101 in DSNKISPL
  ERQUAL5003 and the index affected is set in logical page
  list(LPL).
  

Problem conclusion

• DB2 code has been updated to reserve enough space for the
  index key delete to roll back successfully when the
  insert transaction replaces a pseudo deleted entry in a
  unique index and there is also SQL with isolation
  level repeatable read running in the system.
  

Temporary fix

Comments

APAR Information

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

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

  PI80858 UI47302

Modules/Macros

• DSNKCKOP DSNKINSL
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI47302

     UP17/06/01 P F705

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.