A fix is available
APAR status
Closed as program error.
Error description
The problem can happen for paralllelism if a table in the query has a partitioning index that has INCLUDE columns. Keywords: DB2OVRLAY/K SMCOVERLAY sqlparallelism
Local fix
disable parallelism
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 10 for z/OS users of parallelism * * who have queries on a table with an index * * defined with INCLUDE columns. * **************************************************************** * PROBLEM DESCRIPTION: ABEND04E RC00E2000F in DSNXOAF +0858 * * on a query in parallelism when the * * partitioning index is defined with * * INCLUDE columns * **************************************************************** * RECOMMENDATION: * **************************************************************** ABEND04E RC00E2000F in DSNXOAF +0858 can occur on a query in parallelism when the partitioning index is defined with INCLUDE columns. A storage overlay may happen where PCAC blocks can go beyond the allocated space. This will result in the abend when DB2 attempts to free storage. Additional Keywords: SQLSTORAGE DB2OVRLAY/K SMCOVERLAY SQLINCLUDE DB2PARALL/K OFFSET0858
Problem conclusion
Code is changed so that the correct amount of storage will be allocated for PCAC blocks.
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PM82595
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
2013-02-12
Closed date
2013-03-18
Last modified date
2013-05-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK92625
Modules/Macros
DSNXOLCM DSNXOLM1
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RA10 PSY UK92625
UP13/04/03 P F304
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 May 2013