PH65141: ABEND0C9 00000009 IN DSNKCEST OFFSET039AA DURING SQL DELETE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Executing an SQL DELETE on a PBR TS leads to ABENDS0C9 PIC09
  in DSNKCEST offset+039AA (MOD DSNKCEST was at base level). The
  problem happened in the context of a large UNIQUE INDEX with
  lots of levels. The DSN1PRNT showed that IPLEVEL='0F'X for the
  INDEX NON-LEAF PAGE (page 00000002).
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 13 for z/OS users using large        *
  *                 indexes.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: While executing an SQL DELETE on a      *
  *                      PBR table space, an ABND=0C9-00000009   *
  *                      in module DSNKCEST (offset+039AA)       *
  *                      occurred. The abend was triggered       *
  *                      by processing a large UNIQUE INDEX      *
  *                      containing lots of levels within the    *
  *                      index. A DSN1PRNT of the failing        *
  *                      index showed that IPLEVEL='0F'X for     *
  *                      the INDEX NON-LEAF PAGE                 *
  *                      (page 00000002).                        *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  The SQL DELETE caused Db2 processing to try and estimate the
  number of index entries that existed in the failing index.
  During the estimation process, the large number of index
  levels caused a calculated value to exceed its capacity,
  leading to the ABND=0C9-00000009.
  

Problem conclusion

• Db2 code has been modified to increase the capacity of the
  calculated value to avoid the ABND=0C9-00000009.
  

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:

  UO03022

Modules/Macros

• DSNKCEST
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RD10 PSY UO03022

     UP25/05/09 I 1000

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.