PH17750: ABEND0C4 RC00000004 AT DSNXOMS OFFSET02980 OCCURRED ON A QUERY WITH MULTIPLE INDEX ACCESS AND PARTITION PRUNING

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND0C4 RC00000004 at DSNXOMS OFFSET02980 occurred on a query
  with multiple index access and partition pruning with join
  predicate.
  
  Additional Keywords:
  SQLACCESSPATH
  MIDX
  SQLPRUNING
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users with query using                   *
  * multiple index access and partition                          *
  * pruning on join predicate.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * ABEND0C4 RC00000004 at DSNXOMS                               *
  * OFFSET02980 may occur on a query                             *
  * with multiple index access and                               *
  * partition pruning with join predicate.                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  ABEND0C4 RC00000004 at DSNXOMS OFFSET02980 may occur on a
  query with multiple index access and partition pruning with
  join predicate.
  An example for the error case is:
     select * from T1, T2
     where T1.c1 = T2.c1  and
           T1.c2 = T2.c2  and
           T1.c3 = T2.c3
  T2 is mulitple index access with index of I1(c1), I2 (c2)
  and I3(C3) and key partitional pruning used on join predicate.
  Additional keywords:
  MIDX SQLACCESSPATH SQLPRUNING
  

Problem conclusion

• Db2 code is  modified to reference the correct data
  structure.
  

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:

  UI67083

Modules/Macros

• DSNXOGCM DSNXOMI
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI67083

     UP19/12/25 P F912

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.