A fix is available
APAR status
Closed as program error.
Error description
The storage used by the RLPL block in the ECSA leaks after a soft cancel(RC00E50013) is issued for the Sysplex parallelism thread. The soft cancal was issue by DSNTTNO3 +1968 UK55384.
Local fix
turn off SYSPLEX QUERY PARALLELISM.
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 9 for z/OS and 10 for z/OS users * * with SYSPLEX parallelism enabled. * **************************************************************** * PROBLEM DESCRIPTION: ECSA storage leak after SYSPLEX query * * parallel thread is soft cancelled. * **************************************************************** * RECOMMENDATION: * **************************************************************** ECSA storage leak after SYSPLEX query parallelism thread is soft cancelled. After DB2 parallel thread acquires ECSA storage, it is cancelled and DB2 does not handle this error situation correctly. The problem is not query specific and the problem can be avoided by turning off the SYSPLEX parallelism support.
Problem conclusion
DB2 has been fixed to release acquired ECSA storage after the SYSPLEX parallel thread has been cancelled, so that after the fix, the storage leak problem will be fixed. Additional Keywords: PARALLELISM SYSPLEX SQLSYSPLEXP DB2PARALL/K SQLSTORAGE
Temporary fix
Comments
APAR Information
APAR number
PM72885
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-09-13
Closed date
2012-11-26
Last modified date
2013-01-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK83731 UK83732
Modules/Macros
DSNXPSEN
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":"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:
02 January 2013