A fix is available
APAR status
Closed as program error.
Error description
DB2DDF DDFL09 defect pk93136 dpk93136 DRDS DBAA DDF POOL is full because most storages are used for SQLCA for CNTQRY but not freed correctly. So we get abend 04E-00E20004 in DSNLXCQ6 *************************************** Additional keywords and symptoms: ABEND04E ABND04E AB04E S004E 04E 00E20003 RC00E20003 00E20004 RC00E20004 00E2000B RC00E2000B 00E20015 RC00E20015 00E20016 RC00E20016 in DRDS DBAA DDF POOL SP229 KEY7 Short on Storage SOS DB2STGLK/K
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: All Distributed Data Facility (DDF) users. * **************************************************************** * PROBLEM DESCRIPTION: The following abend occured in the DB2 * * ssnmDIST address space due to lack of * * virtual storage: * * . ABEND04E-00E20004 * * DSNLXCQ6.DSNSVBK:05F8 * * * * In the resulting dump, a large amount * * of storage is consumed by storage pools * * with the following eyecatcher: * * . "DRDS DBAA DDF POOL" - * * ssnmDIST subpool 229 key 7 * * * * The storage pools contain a large * * number of control blocks with the * * eyecatcher "SQLCA". * **************************************************************** * RECOMMENDATION: * **************************************************************** An application at a DRDA requester system executing at DRDA SQLAM level 6 (or lower) repeatedly fetches from a cursor at a DB2 9 for z/OS server. During fetch processing, DB2 acquires storage for a SQLCA control block even though one already exists for that cursor section. Over time, as the remote client continually fetches against the same cursor, this storage accumulation of SQLCA control blocks can lead to "short on storage" related symptoms, such as DB2 Storage Manager component abends including: . 04E-00E20003 . 04E-00E20004 . 04E-00E2000B . 04E-00E20015 . 04E-00E20016 NOTE: This problem affects only requesters executing at DRDA SQLAM level 6 or lower (such as DB2 UDB for OS/390 and z/OS V7) where the requester is connected via DRDA to DB2 9 for z/OS servers. Requesters that use long lived threads or commit infrequently increase the chances of encountering this problem.
Problem conclusion
The DB2 9 for z/OS server has been changed to allocate SQLCA control blocks only if one does not exist. This prevents the growth of distributed address space virtual storage and the resulting storage manager abends.
Temporary fix
Comments
APAR Information
APAR number
PK93136
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-08-05
Closed date
2009-09-09
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:
UK49948
Modules/Macros
DSNLXCQ6
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
R910 PSY UK49948
UP09/09/24 P F909
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