PI81984: 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 11 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:                                              *
  ****************************************************************
  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 PI82133 will be used for DB2 12 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:

• APAR is sysrouted TO one or more of the following:

  PI82133 UI48151

Modules/Macros

• DSNXRRID DSNXSFRT DSNXSFTP
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI48151

     UP17/07/06 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.