IBM Support

PK86347: ABEND04E RC00E70005 DSNXRPJP:M117

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PK86347

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-05-11

  • Closed date

    2009-06-12

  • Last modified date

    2011-05-18

  • 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.



Document information

More support for: DB2 for z/OS

Software version: 910

Reference #: PK86347

Modified date: 18 May 2011


Translate this page: