A fix is available
APAR status
Closed as program error.
Error description
ABEND04E RC00E72200 AT DSNXSFPR OFFSET25A0
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 * * the RIDs. * **************************************************************** * PROBLEM DESCRIPTION: An ABEND04E RC00E72200 at DSNXSFPR * * +25A0 (OFFSET25A0) can result when the * * number of input RIDs is different from * * the number of RIDs that were * * partitioned. This can occur if the * * number of RIDs is larger than 2G * * because one of the internal counters * * was defined differently or incorrectly. * **************************************************************** * RECOMMENDATION: * **************************************************************** An ABEND04E RC00E72200 can occur at location DSNXSFPR offset 25A0 when the number of input RIDs is different from the number of RIDs that were partitioned. This can occur if the number of RIDs is larger than 2G because one of the internal counters was defined incorrectly which can result in a false comparison between a negative number and a very large positive number.
Problem conclusion
DB2 has been modified to define the internal RID counters to be identical to avoid this comparison problem. Additional Keywords: SQLRID PARALLELISM SQLPARALLELISM DB2PARALL/K
Temporary fix
Comments
APAR Information
APAR number
PI31545
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2014-12-15
Closed date
2015-01-05
Last modified date
2015-02-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI24220 UI24221
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"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
15 March 2024