IBM Support

PM79464: ABEND04E RC00E70005 AT DSNXOSR:P014 WHEN PARALLELISM IS ON AND MERGC = YES & SORTN_JOIN = YES & PRIMARY_ACCESSTYPE = 'T'

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Abend04e rc00e70005 at DSNXOSR:P014 may happen when explain
    query which is in parallelism and explain shows row with MERGC =
    YES & SORTN_JOIN = YES & PRIMARY_ACCESSTYPE = 'T'.
    Abend04e rc00e72048 at DSNXSORI OFFSET 56C6 may also happen
    while running the query.
    

Local fix

  • Disable parallelism
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 10 for z/OS users of parallelism.    *
    ****************************************************************
    * PROBLEM DESCRIPTION: An ABEND04E RC00E70005 DSNXOSR:P014     *
    *                      may occur when a query has one miniplan *
    *                      with PARALLELISM ON and MERGC = YES     *
    *                      and SORTN_JOIN = YES and                *
    *                      PRIMARY_ACCESSTYPE = 'T' and the query  *
    *                      contains a GROUP BY clause.             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    An ABEND04E RC00E70005 DSNXOSR:P014 may occur when a query has
    one miniplan with PARALLELISM ON and MERGC = YES and
    SORTN_JOIN = YES and PRIMARY_ACCESSTYPE = 'T' and the query
    contains a GROUP BY clause.
    The following is an example of such failing SQL:
    SELECT T1.C1, T1.C2, T1.C3
      FROM T1, T2
     WHERE T2.C1 ...
       AND T1.C4 ..
    GROUP BY T1.C1, T1.C2, T1,C3
    Note:
    T1 NLJ T2, T2 miniplan shows MERGC = YES, parallel join,
    SORTN_JOIN = YES and PRIMARY_ACCESSTYPE = 'T'.
    

Problem conclusion

  • The bindtime code in DB2 is modified to correct the sort key
    set up for a query with a GROUP BY clause that has
    SORTN_JOIN = YES and PRIMARY_ACCESSTYPE = 'T' and MERGC = YES
    and parallelism is ON.
    
    Additional Keywords: ABEND04E RC00E70005 SQLGROUPBY SQLNLJ NLJ
                         SQLPARALLELISM SQLCPUP DEGREEANY
                         DB2PARALL/K PARALLELISM
                         SQLSPARSEINDEX SPARSEINDEX MERGC
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    PM79464

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-12-18

  • Closed date

    2013-03-13

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

    UK92492

Modules/Macros

  • DSNXOSR
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK92492

       UP13/03/28 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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
02 April 2013