A fix is available
APAR status
Closed as program error.
Error description
DBM1 storage is not being freed when running REPAIR DBD DIAGNOSE nd the storage growth is connected to the number of triggers in the database. Abend04e in DSNGEPIS DSNSVBK OFFSET061A with RC000E20003. . 2/ ABEND04E RC00E20004DSNXEAB DSNSVSVB 0446 also possible with PHB at MAX size / 2G / ADMF AGL 64 XXXXXXXX Var 2097064 K 20 0 in storage above the bar DSNXOOP +004F15 UK45067 DSNXOAF +000931 UK28994 are major storage consumers DB2STGLK/K
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 users who use REPAIR DBD utility * **************************************************************** * PROBLEM DESCRIPTION: ABEND04E RC00E20003 DSNGEPIS.DSNSVBK * * 061A or ABND04E RC00E20004 * * DSNXEAB.DSNSVSVB 0446 may occur when * * performing REPAIR DBD DIAGNOSE on * * database with many triggers * **************************************************************** * RECOMMENDATION: * **************************************************************** ABEND04E RC00E20003 DSNGEPIS.DSNSVBK 061A or ABND04E RC00E20004 DSNXEAB.DSNSVSVB 0446 may occur when performing REPAIR DBD DIAGNOSE on a database with many triggers. The ABEND is caused by a storage shortage during REPAIR DBD processing. When the REPAIR DBD utility is processing the triggers in the database, it is not properly freeing acquired storage. When the number of triggers in the database is high, this causes DB2 to run out of storage when executing REPAIR DBD DIAGNOSE utility.
Problem conclusion
DB2 is modified to free storage properly when executing utility REPAIR DBD DIAGNOSE. Additional keywords: SQLSTORAGE SQLTRIGGER
Temporary fix
Comments
APAR Information
APAR number
PK98337
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-10-09
Closed date
2009-11-23
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:
UK52223 UK52224
Modules/Macros
DSNXOOP
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":"8.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":"8.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
15 February 2011