IBM Support

PK78787: ABEND04E RC00E70005 DSNXEFDA M500 CALLER IS DSNXPRE3 AND PARALLELISM IS ENABLED OR DSNXPMGR DSN :P000

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • ABEND04E RC00E70005 DSNXEFDA M500 caller is DSNXPRE3 and
    PARALLELISM is enabled
    .
    Second problem being fixed, Abend
    "ssid,ABND=04E-00E70005,U=user1  ,M=(N),C=910.RDS
     -SORTGRP ,M=DSNTFRCV,LOC=DSNXPMGR.DSN     :P000"
    save area
    DSNTTRUN 05/07/08 UK36263 +000EBE EPA: DSNXEET
    DSNXEET  02/15/08 UK33756 +001C2C EPA: DSNXRTSC
    DSNXRTSC 01/08/09 PK77828 +003582 EPA: DSNXRSOR
    DSNXRSOR 07/09/08 UK37972 +000862 EPA: DSNXSORI
    DSNXSORI 09/11/08 UK39795 +001848 EPA: DSNXSTSG
    DSNXSTSG 09/11/08 UK39795 +00185C EPA: DSNXSING
    DSNXSING 12/14/07 UK32290 +0003DE EPA: DSNXRSJ
    DSNXRSJ  01/08/09 PK77828 +0014DA EPA: DSNXRT2J
    DSNXRT2J 03/30/07 UK23586 +000296 EPA: DSNXPRE3
    Additional keywords: DB2PARALL/K
    

Local fix

  • disable paralelism
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: ALL DB2 R810 AND R910 PARALLELISM USERS.     *
    ****************************************************************
    * PROBLEM DESCRIPTION: An ABEND04E RC00E70005 DSNXEFDA:M500    *
    *                      with caller DSNXPRE3 OR DSNXPMGR        *
    *                      DSN     :P000 may occur for querys that *
    *                      choose SORT MERGE JOIN or STAR JOIN     *
    *                      and PARALLELISM is enabled.             *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    An ABEND04E RC00E70005 DSNXEFDA:M500 with caller DSNXPRE3 or
    DSNXPMGR DSN    :P000 for querys that choose SORT MERGE JOIN
    or STAR JOIN and PARALLELISM is enabled.
    

Problem conclusion

  • DB2 is fixed to setup the parallelism structure correctly.
    Additional keywords: PARALLELISM SQLCPUP DEGREEANY
                         SMJ SQLSMJ MSJ SQLMSJ STARJOIN
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK78787

  • 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-01-15

  • Closed date

    2009-03-10

  • Last modified date

    2011-04-28

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

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

    UK44821 UK44822

Modules/Macros

  •    DSNXOBM  DSNXORES DSNXOSG  DSNXOSTA
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R810 PSY UK44821

       UP09/03/27 P F903

  • R910 PSY UK44822

       UP09/03/27 P F903

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

Modified date: 28 April 2011


Translate this page: