A fix is available
APAR status
Closed as program error.
Error description
ABEND04E RC00E2000C at DSNGDCOB DSNSVSVB OFFSET0AD8 when partitioning RIDMAP into workfiles with PARALLELISM Thread AGL 64 pool is full of control blocks with WKFD allocated by DSNXSFPR for xC0 xslot.
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 10 and DB2 11 for z/OS users of * * queries where parallelism needs to partition * * RIDs into workfiles. * **************************************************************** * PROBLEM DESCRIPTION: An ABEND04E RC00E2000C at DSNGDCOB * * DSNSVSVB (OFFSET0AD8) can occur when * * parallelism needs to partition RIDs * * into workfiles and finds that no * * storage is available. * **************************************************************** * RECOMMENDATION: * **************************************************************** An ABEND04E RC00E2000C at DSNGDCOB DSNSVSVB (OFFSET +0AD8) can occur when parallelism needs to partition the RIDs into workfiles and finds no storage available. The problem occurs because the module which performs the partitioning kept on acquiring storage for an internal workfile descriptor control block but never freed it upon exit. Thus, a slow growing catalyst. So if an application is long running and continues to use parallelism with this kind of RID partitioning, then this storage can continue to accummulate resulting in a short on storage condition.
Problem conclusion
DB2 has been modified to free the storage for the workfile descriptor control block upon exit from the module that acquires the storage. This will prevent the accumulation and short-on-storage condition previously mentioned. Additional Keywords: SQLRID PARALLELISM SQLPARALLELISM DB2PARALL/K SQLSTORAGE DB2STGLK/K
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PI41431
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
2015-05-20
Closed date
2015-06-09
Last modified date
2015-07-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI28342 UI28343
Modules/Macros
DSNXSFPR
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":"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:
01 July 2015