IBM Support

PK84056: D123895. ABEND04E RC00E70005 DSNXRPJP:M511 WHEN A PAIR-WISE JOIN PARALLEL GROUP IS DEGENERATED WHEN AN AMBIGUOUS CURSOR DETECTED.

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • D123895. ABEND04E rc00E70005 occurs at dsnxrpjp:m511 when a
    pair-wise join parallel group is degenerated when an
    an ambiguous cursor is detected.
    
    DB2INCORR/K
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2/Zos users using dynamic index        *
    *                 anding for starjoin queries.                 *
    ****************************************************************
    * PROBLEM DESCRIPTION: When pairjoin starjoin is utilized,     *
    *                      several problems may occur.             *
    *                                                              *
    *                      1. Incorrectout may occur when a        *
    *                      dimension is used in one of the         *
    *                      pairjoin legs and the following         *
    *                      conditions are satisfied.               *
    *                                                              *
    *                      1.1 There are multiple join predicates  *
    *                      between the dimension and the fact      *
    *                      table                                   *
    *                      1.2 In one of the join predicates,      *
    *                      there are data type mismatch between    *
    *                      the left side and right side columns.   *
    *                                                              *
    *                      2. An ABEND04E RC00E70005 at            *
    *                      DSNXRPJP:M511 may occur when executing  *
    *                      DYNAMIC INDEX ANDING query the          *
    *                      referenced database/tablespace/table    *
    *                      is unavailable.                         *
    *                                                              *
    *                      3. An ABEND at DSNXRPJP+081C may occur  *
    *                      when executing DYNAMIC INDEX ANDING     *
    *                      query, the parallel group is            *
    *                      degenerated due to ambiguous cursor     *
    *                      detected.                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When pairjoin starjoin is utilized, several problems
    may occur.
    
    1. Incorrectout may occur when a dimension is used
    in one of the pairjoin legs and the following
    conditions are satisfied.
    
    1.1 There are multiple join predicates between the
    dimension and the fact table
    1.2 In one of the join predicates, there are data
    type mismatch between the left side and right side
    columns.
    
    2. An ABEND04E RC00E70005 at DSNXRPJP:M511 may occur when
    executing DYNAMIC INDEX ANDING query the referenced database/
    tablespace/table is unavailable.
    
    3. An ABEND at DSNXRPJP+081C may occur when executing DYNAMIC
    INDEX ANDING query, the parallel group is degenerated due to
    ambiguous cursor detected.
    

Problem conclusion

  • 1.The incorrectout problem described above is fixed by not
    using the dimensions satisfying the two conditions in
    pairjoin legs.
    
    2. DB2 is modified to issue a SQLCODE -904 resource unavailable
    message instead of abending in DSNXRPJP:M511.
    
    3. DB2 is modified to handle the parallel group degeneration
    when executing DYNAMIC INDEX ANDING query and an ambiguous
    cursor is detected.
    
    Additional Keywords: SQLPAIRWISEJOIN SQLSTARJOIN
                         SQLINCORR INCORROUT
    

Temporary fix

  • *********
    * HIPER *
    *********
    

Comments

APAR Information

  • APAR number

    PK84056

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-04-03

  • Closed date

    2009-04-28

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

    UK46164

Modules/Macros

  •    DSNXOSJX DSNXRPJP DSNXRTSC
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R910 PSY UK46164

       UP09/05/22 P F905

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 #: PK84056

Modified date: 18 May 2011


Translate this page: