A fix is available
APAR status
Closed as program error.
Error description
ABEND04E RC00E20003 or RC00E20004 for ADMF AGL 31 pool or CTLNGSTP. The pool is filled with SelP structures. Creating module for this structure is DSNIGSEL This happens for the process using the created temp table CGTT SQLCGTT DB2STGLK/K
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 10 for z/OS (CM and above) users of * * created global temporary tables (CGTT) * **************************************************************** * PROBLEM DESCRIPTION: ABEND04E DSNSVBK RC00E20003 RC00E20004 * * on ADMF AGL 31 pool while running CGTT * * application * **************************************************************** * RECOMMENDATION: * **************************************************************** Storage leak may occur in the ADMF AGL 31 storage pool (CTLNGSTP) after continued runs of queries that use CGTTs. The leak involves the so-called P Procs or PProcs (predicate procs), new in V10 CM and higher, when they are built for CGTT. The eyecatcher in the dump was 'SelP'. The particular reported case for this APAR involved the CGTT application going through bind or dynamic prepare processing. Even though a P Proc, as expected, was not built at bind time/ dynamic prepare time, a bit in the internal MSIB structure remained on by mistake through runtime, implying that it is OK to build the P Proc. However, P Procs are not supported for CGTTs as there is no freeing infrastructure in place for such cases.
Problem conclusion
Code has been changed to ensure that the internal MSIB bit which affects P Proc building is not left on past bindtime/dynamic prepare time for CGTTs. In addition, code has been added for execution time (runtime) to ensure that P Procs are not built for CGTTs, so that a rebind is not necessary for this APAR to become effective. Additional keywords: DB2STGLK/K SQLCGTT
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PM67539
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-06-22
Closed date
2012-08-08
Last modified date
2012-09-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK80931
Modules/Macros
DSNIIMSI DSNXOMI DSNXOMS
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RA10 PSY UK80931
UP12/08/24 P F208
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:
05 September 2012