PK86347: ABEND04E RC00E70005 DSNXRPJP:M117

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABENDS04E in DSNXRPJP M117 (location MINUS 117 -117) for a
  query due to a timing window exposure.  With RIDMAP processing
  and parallel processing, the child task went away before the
  RIDMAP could be copied from its memory to the parent memory.
  pair wise join is invloved.
  DB2PARALL/K
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 z/OS R910 Pair-Wise Join query       *
  *                 users.                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E in DSNXRPJP:M117 may occur     *
  *                      when a PAIR-WISE JOIN query exposes     *
  *                      to a timing window.                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  ABEND04E in DSNXRPJP:M117 may occur when a PAIR-WISE JOIN
  query exposes to a timing window.
  

Problem conclusion

• DB2 is modified to seal the PAIR-WISE JOIN query timing
  window.
  
  Additional Keywords: PARALLELISM SQLPAIRWISEJOIN
  

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:

  UK47394

Modules/Macros

• DSNXPRE2 DSNXRPJP DSNXRSJC DSNXRT
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R910 PSY UK47394

     UP09/06/27 P F906

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.