A fix is available
APAR status
Closed as program error.
Error description
The following abend occurred: DSN ,ABND=04E-00E20003,U=uuuuuuu ,M=C9 ,C=101.DMC -DSNIISRT, DISTRBUTED,LOC=DSNICUBD.DSNSVBK +070E The caller of storage obtain was DSNICUBD +0F8F . The last entries in save flow were: DSNISRTI -> DSNIZAZ2 -> DSNICUBD -> DSNSVBK . The dump showed about 5200 pieces of 108K bytes of CUBD storage blocks that were allocated for IPROC . Also the dump showed heavy use of ( insensitive ) static scrollable cursors and at least 5200 internal active DGTTs created with ' on commit delete rows '. All of these internal DGTTs had their associated IPROC allocated , size 108k . In this case there was no COMMIT being performed periodically , so the DGTT CUBs along with their IPROC blocks were still around with the thread . More frequent commits while using static scrollable cursors may help. DB2STGLK/K
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: DB2 10 for z/OS users performed insert * * operations to DGTT tables. * **************************************************************** * PROBLEM DESCRIPTION: Various abends occurred while doing the * * insert operations, such as ABEND04E * * RC00E20003 DSNSVBK +070E or ABEND04E * * RC00E20013 DSNSGMN +1104. * **************************************************************** * RECOMMENDATION: * **************************************************************** DB2 experienced storage shortage and caused the DB2 system to crash. The storage shortage is caused by excessive number of IPROC blocks being accumulated due to previous insert operations to many DGTT tables. DB2 did not release or reuse those IPROC storage at a proper time.
Problem conclusion
DB2 code is fixed to properly release the IPROC storage and reuse it when the next new IPROC is to be allocated.
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PM64646
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt
Submitted date
2012-05-15
Closed date
2012-08-17
Last modified date
2013-02-27
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK81177
Modules/Macros
DSNICINV DSNICMT2 DSNICPOS DSNICREL DSNICUBC DSNICUBD DSNIDALC DSNIRSVP DSNISRTI DSNITCUS
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RA10 PSY UK81177
UP12/09/05 P F209
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"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
27 February 2013