A fix is available
APAR status
Closed as program error.
Error description
DB2 V9 DataSharing ABND=04E-00E20006 causing a DB2 crash. Dump Title: DBP1,ABND=04E-00E20006,U=PRDBAT ,M=(N),C=910.DMC -IBABR ,M=DSNTFRCV,LOC=DSNIBABR.DSNSVBK +1CA0 Above abend was issued after ABEND04E RC00C200B0 in DSNB1REL. Both of them were issued due to storage overlay. During the allocation of plan S6030 section 7, too small storage was obtained for the section and loading the section from DSNDB01.SCT01 overlaid following area of the obtained storage. The length of the section was gotten from a directory section. But the directory section for the plan had been already freed and reused. The ABEND04E RC00C200B0, RC00E20006 and DB2 crash was caused by a storage overlay which happened while loading plan S6030 section 7. Additional symptoms : 00C200B0 IN DSNB1REL 04E 00E20006 DSNIBABR DSNSVBK OFFSET1CA0 ABEND04E 00C90101 DSNGEDM DSNGEPLC ERQUAL5004 ABND04E 00E20005 DSNGEPLC DSNSVBK OFFSET0994 ABEND0C4 PIC04 AT DSNGEPLC OFFSET67AC 04E 00C90101 DSNGEDM DSNGEPLC ERQUAL5002 ABENDS0C4 00000004 PIC04 DSNGEDM DSNGEPLC OFFSET4E08 DB2OVRLAY/K
Local fix
As workaround, please increase EDM_SKELETON_POOL in ZPARM.
Problem summary
**************************************************************** * USERS AFFECTED: DB2 users with heavy workload that leads * * to re-use of the EDM pool. * **************************************************************** * PROBLEM DESCRIPTION: In a DB2 system with a heavy workload, * * the users may get abends such as : * * ABEND04E RC00E20006 * * DSNIBABR.DSNSVBK +1CA0 * * ABEND04E RC00C90101 * * DSNGEDM.DSNGEPLC:5004 * * ABND04E RC00E20005 * * DSNGEPLC.DSNSVBK +0994 * * * **************************************************************** * RECOMMENDATION: * **************************************************************** When a thread is requesting a plan or package section, the plan/package directory that the thread is accessing might have been re-used by another thread for a different plan/package. This can cause errors or an overlay in reading the section from DASD and results in unpredictable abends including bringing down DB2. The overlay can be on a storage manager control block for the below-the-bar (31 bit) private area.
Problem conclusion
DB2 is corrected to eliminate the window when a directory could be erroneously identified to be valid so that such error will not happen. KEYWORDS: SMCOVERLAY
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PM00604
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt
Submitted date
2009-11-06
Closed date
2010-01-07
Last modified date
2011-02-15
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK53423 UK53424
Modules/Macros
DSNDEDM DSNGECMP DSNGEDFR DSNGEELC DSNGEFBK DSNGEFLC DSNGEFSP DSNGEINT DSNGEPDL DSNGEPER DSNGEPIS DSNGEPLC DSNGEPRR DSNGERBK DSNGESDL DSNGESLC
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
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":"9.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":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
15 February 2011