A fix is available
APAR status
Closed as new function.
Error description
ABEND04E RC00E2000C for ACOMDSC2GP also known as STMT CACHE BLOCKS 2G pool full with DMHE entry when DYNAMIC STMT CACHE is on. The customer observed this with KEEPDYNAMIC(YES) is also turned on causing the cache to be held longer. . This APAR will increase the storage size so DMHE could be allocated more in V9 and V10. This will help allocating more DMHE storage regardless of KEEPDYNAMIC(YES) setting. RC00E7910D
Local fix
KEEPDYNAMIC(OFF)
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 9 and DB2 10 for z/OS users of * * dynamic statement cache. * **************************************************************** * PROBLEM DESCRIPTION: Abend ABND04E RC00E2000C may occur at * * DSNXODMH DSNSVSVB +0AC2 if dynamic * * statement cache is used when * * preparing an SQL statement. * **************************************************************** * RECOMMENDATION: * **************************************************************** Abend ABND04E RC00E2000C may occur at DSNXODMH DSNSVSVB +0AC2 if dynamic statement cache is used when preparing an SQL statement. The abend occurs because DB2 run out of storage when dynamic statement cache is enabled. In this apar, a new field QW0225DMH is added to statistics record IFCID225. This field tracks the accumulated statement dependency (DMHE) storage for statement in the dynamic statement cache.
Problem conclusion
After APAR PM67806, SQLCODE -904 may be issued. A new reason code 00E7910D is added. This is the approximate text of the message: 00E7910D Explanation The available storage space is not sufficient for the dynamic statement cache, due to one of the following conditions: - The value that was specified for the CACHE_DEP_TRACK_STOR_LIM subsystem parameter was exceeded. - The value that was specified for the REALSTORAGE_MAX subsystem parameter was exceeded. - An auxiliary storage shortage occurred. System action SQLCODE -904 is returned with this reason code. System programmer response Take one or more of the following actions: - Increase the value of the CACHE_DEP_TRACK_STOR_LIM subsystem parameter. - Increase the value of the REALSTORAGE_MAX subsystem parameter, or take appropriate actions based on local procedures to reduce the amount of real storage that is being used. - Review console messages for IRA200E or other IRA2nn auxiliary storage warning messages, and take appropriate actions based on local operating procedures to relieve the shortage of auxiliary storage page space.
Temporary fix
Comments
DB2 was fixed to allow more storage to be allocated for the dynamic statement cache. CACHE_DEP_TRACK_STOR_LIM subsystem parameter was added to allow user to set the higher value for the DMHE storage. The value could be 2-10 for gigabytes with the default of 2. Additional Keywords: SQLDYNSTMTCACHE SQLSTOR
APAR Information
APAR number
PM67806
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-06-27
Closed date
2013-07-12
Last modified date
2014-08-13
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK95795 UK95796
Modules/Macros
DSN@XAZP DSNDQWPZ DSNDQW03 DSNDSPRM DSNLTMSC DSNTIDXA DSNTIDXB DSNTIJUZ DSNTINST DSNTXAZP DSNTXSTB DSNVMON DSNWZIFA DSNWZIF9 DSNXODMH DSN6SPRM
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":"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:
13 August 2014