A fix is available
APAR status
Closed as program error.
Error description
Storage leak in the DBM1 address space for long-running threads that run native SQL procedures with the option DEGREE ANY. DB2 may ABEND04E with one of the following reason codes: RC00E20004 RC00E2000B RC00E2000C RC00E20003 .
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of SQLPL Routines with DEGREE ANY * **************************************************************** * PROBLEM DESCRIPTION: Storage leak in the DBM1 address * * space for long running threads that * * run SQLPL routines with the option * * DEGREE ANY. * * . * * DB2 may ABEND04E with one of the * * following reason codes: * * RC00E20003 RC00E20004 RC00E2000B * * RC00E2000C . * **************************************************************** * RECOMMENDATION: * **************************************************************** Excessive storage growth occurs in the DBM1 address space when long running threads run several static sql queries inside SQLPL routines that participate in sql query parallelism. This occurs when you specify the DEGREE ANY option on the SQLPL routine CREATE or ALTER statement. . A control block used in the processing of sql query parallelism under SQLPL routines was not properly freed. . .
Problem conclusion
DB2 code has changed to free the storage. . . Additional Keywords: parallelism sqlparallelism sqlcpup sqliop sysplex sqlsysplexp sqlprocedure native sqlsp sqlstoredproc sqludf sqlnativesqlpl DB2PARALL/K DB2STGLK/K
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PM58526
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-02-17
Closed date
2012-03-09
Last modified date
2012-04-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK76938
Modules/Macros
DSNXECMP
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RA10 PSY UK76938
UP12/03/24 P F203
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:
03 April 2012