PH04208: ABEND04E RC00E70005 DSNXRT2J M111 DURING EXECUTION OF A QUERY USING DATA PARTITIONED SECONDARY INDEX (DPSI) PARALLELISM

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E70005 DSNXRT2J M111 received during execution of a
  query using DPSI parallelism.  The abend can occur when a table
  with a DPSI is chosen by Db2 as the inner table in a nested
  loop join and DPSI parallelism is enabled.
  
  Additional Keywords:
  
  SQLACCESSPATH SQLNLJ NLJ DPSI
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 11 and Db2 12 for z/OS users who     *
  *                 use data-partitioned secondary index (DPSI)  *
  *                 parallelism.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E RC00E70005 DSNXRT2J M111       *
  *                      received during execution of a query    *
  *                      using DPSI parallelism.                 *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available.         *
  ****************************************************************
  ABEND04E RC00E70005 DSNXRT2J M111 received during execution
  of a query using DPSI parallelism.  The abend can occur when a
  table with a DPSI is chosen by Db2 as the inner table in a
  nested loop join and DPSI parallelism is enabled.  The abend
  occurred due to Db2 incorrectly building the parallel groups
  for this case.
  
  Additional Keywords:
  SQLACCESSPATH SQLNLJ NLJ DPSI
  

Problem conclusion

• Db2 code has been changed to correct the problem leading to the
  abend.
  

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:

  UI61686 UI61687

Modules/Macros

•    DSNXOGP2 DSNXOLL
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI61687

     UP19/03/21 P F903

• RC10 PSY UI61686

     UP19/03/21 P F903

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.