A fix is available
APAR status
Closed as program error.
Error description
ABEND04E RC00E70005 AT DSNXRRID M107 WHEN SORT PUTS RIDS IN WORKFILE AND RLF TIME LIMIT IS EXCEEDED
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All DB2 12 for z/OS users of queries that * * use multiple index access and RLF, the * * Resource Limit Facility. * **************************************************************** * PROBLEM DESCRIPTION: * * An ABEND04E RC00E70005 at DSNXRRID * * M107 or at DSNXRRP M700 can occur * * when sort puts RIDs into a workfile * * or merges RIDs when the RLF time * * limit is exceeded. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** An ABEND04E RC00E70005 at DSNXRRID M107 or at DSNXRRP M700 can occur when sort puts RIDs into a workfile or merges RIDs when the RLF time limit is exceeded. DB2 should return an SQLCODE error and message to the user instead of ABENDing. For this error case, an SQLCODE905 or -905 should be returned because the resource limit time is exceeded. Please note, RID access can be identified from EXPLAIN as follows. 1. List prefetch (the PLAN_TABLE PREFETCH column has a value 'L'). 2. Multiple index access (the PLAN_TABLE ACCESSTYPE column has a value 'M','MI', or 'MU').
Problem conclusion
DB2 has been modified to issue an SQLCODE -905 error and message indicating that the resource limit time has been exceeded. Please note that APAR PI81984 will be used for DB2 11 for z/OS to address this same issue. Additional Keywords: SQLCODE905 SQLRID SQLSORT
Temporary fix
Comments
APAR Information
APAR number
PI82133
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-05-25
Closed date
2017-06-19
Last modified date
2017-08-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI48152
Modules/Macros
DSNXSFRT DSNXSFTP DSNXRRID
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI48152
UP17/07/07 P F707
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":"12.0","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":"12.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 August 2017