PI82133: ABEND04E RC00E70005 AT DSNXRRID M107 WHEN SORT PUTS RIDS IN WORKFILE AND RLF TIME LIMIT IS EXCEEDED

Obtain the fix for this APAR.

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 is sysrouted FROM one or more of the following:

  PI81984

• 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.