A fix is available
APAR status
Closed as program error.
Error description
RC00E70005 DSNXOLDE:M010 with a Nested Loop Join using DPSI parallelism when the outer table is a work file from a outer join result.
Local fix
Setting PARAMDEG_DPSI to DISABLE will disable DPSI parallelism.
Problem summary
**************************************************************** * USERS AFFECTED: DB2 11 for z/OS users of DPSI parallelism. * **************************************************************** * PROBLEM DESCRIPTION: ABEND04E RC00E70005 at * * DSNXGRDS.DSNXOLDE:M010 may occur at * * execution time when DPSI parallelism * * is incorrectly selected by DB2 at * * bind/prepare. * **************************************************************** * RECOMMENDATION: * **************************************************************** ABEND04E RC00E70005 at DSNXGRDS.DSNXOLDE:M010 may occur at execution time when DPSI parallelism is incorrectly selected during bind/prepare. Note that DPSI parallelism is not controlled by traditional parallelism settings. As such, DPSI parallelism can be in effect even with PARAMDEG=1. DPSI parallelism can be controlled at the subsystem level via zparm PARAMDEG_DPSI. Additional keywords: ABEND04E RC00E70005 DSNXOLDE SQLDPSI SQLPARALLELISM PARALLELISM DB2PARALL/K
Problem conclusion
DB2 code has been corrected to avoid access paths choices with invalid use of DPSI parallelism.
Temporary fix
Comments
APAR Information
APAR number
PI31519
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2014-12-15
Closed date
2015-01-21
Last modified date
2015-03-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI24543
Modules/Macros
DSNXOLL
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RB10 PSY UI24543
UP15/02/05 P F502
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"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
06 May 2020