A fix is available
APAR status
Closed as program error.
Error description
ABEND04E RC00E2000C DSNSVSVB +0AC2 storage leak Storage pool filled with SLTX_PERF_STATS blocks allocated by DSNXERT . DB2STGLK/K 04E-00E2000C DSNXEDC3 DSNSVSVB OFFSET0AAA also seen
Local fix
Turn off IFCID 53 , IFCID 58 for long running batch jobs.
Problem summary
**************************************************************** * USERS AFFECTED: All users of IFCID 58 on DB2 10 (for z/OS). * **************************************************************** * PROBLEM DESCRIPTION: ABEND04E RC00E2000C at * * DSNXSTM . DSNSVSVB +0AC2 * * . * * ABEND04E RC00E2000C at * * DSNXERT . DSNSVSVB +0AC2 * * . * * Other storage shortage abends possible. * **************************************************************** * RECOMMENDATION: * **************************************************************** In the reported cases, DB2 ADMF AGL 64 pool reached maximum value. This resulted in several storage shortage related abends and subsystem crash. DB2 development determined that storage shortage occurred because the new block introduced in DB2 10 to hold statement level statistics for IFCID 58 was not correctly freed in certain situations.
Problem conclusion
DB2 code has been corrected to free the statement statistics block. RELATED KEYWORDS - 04E AB04E 00E70005 IFCID058 IFCID58 SQLSTORAGE GROWTH LEAK EXCESSIVE RC00E70005 DB2STGLK/K OFFSET0AC2 00E2000C
Temporary fix
********* * HIPER * ********* AM46946
Comments
APAR Information
APAR number
PM46946
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
2011-09-01
Closed date
2011-10-13
Last modified date
2012-04-25
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK72853
Modules/Macros
DSNXECLF DSNXECW DSNXECWA DSNXECWU DSNXERT
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RA10 PSY UK72853
UP11/10/28 P F110
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:
25 April 2012