A fix is available
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 number
PH46303
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
D10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-05-10
Closed date
2022-05-28
Last modified date
2022-09-08
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"DB2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"D10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
08 September 2022