PM80074: ABEND04E RC00E70005 DSNXRPJP M558 RUNNING A JOIN WITH PARALLELISM

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • ABEND04E RC00E70005 running a join with parallelism active.
    Abend occurs in DSNXRPJP at logical offset M558
    Abend is preceded by a negative SQLCODE (unknown).  A second
    attempt running the SQL statement provides success.
    

Local fix

  • Disable Parallelism
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: DB2 9 for z/OS and DB2 10 for z/OS           *
    *                 users of pair-wise join query with           *
    *                 the dynamic statement cache enabled          *
    *                 (CACHEDYN = YES)                             *
    ****************************************************************
    * PROBLEM DESCRIPTION: An ABEND04E RC00E70005 at DSNXRPJP      *
    *                      M558 may occur when a pair-wise join    *
    *                      query is executed multiple times and    *
    *                      the SQL statement is cached and the     *
    *                      previous execution of the SQL statement *
    *                      returned a negative sqlcode.            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    An ABEND04E RC00E70005 at DSNXRPJP M558 may occur when a pair-
    wise join query is executed multiple times in a system with the
    dynamic statement cache enabled (CACHEDYN = YES) and the
    previous execution returned a negative SQLCODE. After a negative
    SQLCODE is issued, a certain variable was not reset in this
    access path, allowing for subsequent executions of the statement
    to receive this error.
    
    The problem can apply to all pair-wise join queries, if and
    only if the pair-wise join query
    1. is executed multiple times and
    2. the system SQL dynamic statement cache is enabled
       (CACHEDYN = YES) and
    3. a negative sqlcode is returned in previous execution of the
       same statement.
    

Problem conclusion

  • DB2 is modified to re-initialize the variable properly before
    pair-wise join is executed.
    
    Additional Keywords: SQLPAIRWISEJOIN SQLDYNSTMTCACHE ABEND04E
                         RC00E70005 DB2PARALL/K
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM80074

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-07

  • Closed date

    2013-02-21

  • Last modified date

    2013-04-02

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UK91885 UK91886

Modules/Macros

  •    DSNXRPJP
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK91885

       UP13/03/08 P F303

  • R910 PSY UK91886

       UP13/03/08 P F303

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.



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM80074

Modified date:

2013-04-02

Translate my page

Machine Translation

Content navigation