PH46303: REORG MATERIALIZATION OF PENDING ALTER GETS -913 FROM DSNXIPND WITH CONCURRENT RI DELETE CASCADE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• REORG materialization of pending ALTER gets -913 from DSNXIPND
  with concurrent RI DELETE CASCADE
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 13 for z/OS users that use cached                    *
  * dynamic statement bound                                      *
  * with RELEASE(DEALLOCATE).                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The application used Cache Dynamic                           *
  * statement bound with                                         *
  * RELEASE(DEALLOCATE) abended with                             *
  * 04E-00C9010C at DSNXECW+10186.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  When the application which contained cached dynamic statement
  and bound with RELEASE(DEALLOCATE) did a ROLLBACK, an internal
  counter in Db2 that holds a total number of held cursor blocks
  for each Db2 agent contained a negative value. Once this
  condition was detected, DB2 then failed the unit of work with
  abend with 04E-00C9010C in DSNXECW+10186.
  

Problem conclusion

• Db2 code has been corrected to bypass resetting the internal
  counter when it is cached dynamic statement and bound with
  RELEASE(DEALLOCATE)case when the application did a ROLLBACK.
  

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:

  UI80757

Modules/Macros

• DSNICMTC
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RD10 PSY UI80757

     UP22/06/08 P F206

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.