PI80636: ABEND0C4 RC04 DSNXRRID OFFSET008AE WITH RID LIST ACCESS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND0C4 RC04 DSNXRRID OFFSET008AE during RID LIST
  processing.
  
  Additional Keywords:  SQLRID SQLMIDX MIDX
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 11 for z/OS users of RID list        *
  *                 access.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: An ABEND0C4 can occur at DSNXGRDS       *
  *                      DSNXRRID OFFSET008AE when using         *
  *                      RID list access.                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An ABEND0C4 can occur at location DSNXGRDS DSNXRRID
  OFFSET008AE during RID list processing.
  
  Additional conditions necessary for the ABEND to occur are:
  
  1. A multiple index scan of 3 or more indexes is performed.
     The PLAN_TABLE  ACCESSTYPE column shows 'MU'.
  
  2. There is no join, parallelism, hash access, or set function.
  
  
  The following example illustrates a failing case.
  
  Step 1. Create Table TAB and indexes.
  
     CREATE TABLE TAB
     (COL1 INTEGER,
      COL2 INTEGER,
      COL3 INTEGER,
      COL4 INTEGER);
  
     CREATE INDEX COL1IX ON TAB (COL1);
     CREATE INDEX COL2IX ON TAB (COL2);
     CREATE INDEX COL3IX ON TAB (COL3);
  
  
  Step 2. Perform the following query.
  
     SELECT  COL1
       FROM TAB
       WHERE       COL1 < 1
               OR  COL2 < 4
               OR  COL3 < 10;
  
  The above query can result in the above stated ABEND.
  

Problem conclusion

• DB2 code was modified to prevent the ABEND.
  
  Please note that APAR PI80712 will correct this problem
  in DB2 12 for z/OS.
  
  Additional Keywords:  SQLRID SQLMIDX MIDX
  

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:

  PI80712 UI47403

Modules/Macros

• DSNXRRID
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI47403

     UP17/06/07 P F706

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.