A fix is available
APAR status
Closed as program error.
Error description
Running a DSNREXX program as a stored procedure, over and over in a WLM address space, the WLM address eventually abends with an out of storage condition. A storage leak has been identified.
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: DSNREXX users of DB2 9 for z/OS, DB2 10 * * for z/OS and DB2 11 for z/OS * * who use DSNREXX to create stored * * procedures * **************************************************************** * PROBLEM DESCRIPTION: Users running DSNREXX stored * * procedures which are called * * repeatedly may experience out of * * storage conditions due to subpool 78 * * being exhausted, resulting in ABEND878 * * REASON 10 abend codes. * **************************************************************** * RECOMMENDATION: * **************************************************************** Various abends may occur, depending on environment circumstances when storage is exhausted. Along with the above mentioned abend, users could also receive (and are not limited to) the following abends: ABEND04E RC00E20015 in DSNSLD1 DSNSVSTK +05C6 ABEND04E RC00E20016 in DSNSLD1 DSNSVSTK +0634
Problem conclusion
DSNREXX has been changed to properly free storage from previous executions instead of orphaning / leaking storage. Additional Keyword: DB2STGLK/K SQLSTOREDPROC ABENDS878 OFFSET056C OFFSET0634
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PM95800
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt
Submitted date
2013-08-26
Closed date
2014-05-06
Last modified date
2014-06-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI17723 UI17724 UI17726
Modules/Macros
DSNTZAAA
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RA10 PSY UI17723
UP14/05/22 P F405 ½
RB10 PSY UI17724
UP14/05/22 P F405 ½
R910 PSY UI17726
UP14/05/22 P F405 ½
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:
03 June 2014