PH66535: ABEND04E RC00C90101 IN DSNIRNXT ERQUAL100A DURING SQL SELECT OF AN XML TB

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABND=04E-00C90101 in DSNIRNXT:100A (offset+23596) happened
  during SQL SELECT on a table with XML column. The ABEND is
  accompanied by message DSNI014I, the referenced page is a data
  page (of a PBG TS), and it is marked as broken (DSN1990I).
  
  Running CHECK INDEX or CHECK DATA on the involved objects did
  not indicate a problem or an inconsistency.
  
  Additional symptoms: 00C90101 DSNITCUS 1004 ERQUAL1004
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 13 for z/OS users that run a query   *
  *                 that contains XML column(s) using the WITH   *
  *                 HOLD cursor.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND=04E-RC00C90101 in DSNIRNXT with   *
  *                      ERQUAL100A occurred on a query that     *
  *                      contains XML column(s) using WITH HOLD  *
  *                      cursor.                                 *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  When the Db2 user is running a query that contains XML
  column(s) Using the WITH HOLD cursor, Db2 will release the XML
  lock at the commit time, but it didn't set an internal control
  flag correctly. After the commit time, Db2 reran the same
  query based on the wrong flag to unlock the already
  freed lock. This caused the reported 04E abend in DSNIRNXT.
  

Problem conclusion

• Db2 code has been modified to set the internal flag correctly
  to remember the XML lock has been freed at the commit time,
  and do not call unlock again.
  

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:

  UO04151

Modules/Macros

• DSNIACCH DSNIADR  DSNICMT2 DSNICMTC DSNIDILS DSNIONXP DSNIRNXT
  DSNIRPRE DSNIRPRV DSNIRSET DSNISRID DSNITCUS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RD10 PSY UO04151

     UP25/07/29 P F507

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.