IBM Support

PI93674: ABEND04E RC00E70005 DSNXEBR M666 CAN OCCUR WHEN RUNNING A QUERY 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 DSNXEBR M666 CAN OCCUR WHEN RUNNING A QUERY
    WITH PARALLELISM.
    

Local fix

  •  Disable parallelism.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Db2 11 for z/OS and Db2 12 for z/OS                      *
    * users of parallelism.                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * An unexpected ABEND04E RC00E70005 at                         *
    * DSNXEBR M666 can occur when running a                        *
    * query with parallelism.                                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply corrective PTF when available                          *
    ****************************************************************
    An unexpected ABEND04E RC00E70005 at DSNXEBR M666 can occur when
    running a query with parallelism.
    
    A dump title similar to this would show this error.
    
    ABND=04E-00E70005,U=LGB0227 ,M=N  ,C=121.LOCN
    =::FFFF:9.30.178.   ,LOC=DSNXGRDS.DSNXEBR :M666
    
    This error can occur when, for example, a child parallel task
    issues an SQLCODE904 (resource unavailable) message and exits
    with the error back to the parent.  The parent pulls the error
    messages from the child task's storage to the parent's task
    SQLCA.  This would normally occur during the query's exit
    processing.  However, the above abend can occur when the child
    thread's error message is not ready yet.
    

Problem conclusion

  • The code in Db2 is modified to bypass and prevent the abend
    and allow the error messages to be processed from the child
    tasks.
    
    Additional Keywords: PARALLELISM SQLPARALLELISM DB2PARALL/K
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI93674

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-02-12

  • Closed date

    2018-03-27

  • Last modified date

    2018-05-01

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

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

    UI54768 UI54770

Modules/Macros

  • DSNXEBR
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RC10 PSY UI54768

       UP18/04/11 P F804

  • RB10 PSY UI54770

       UP18/04/11 P F804

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

Reference #: PI93674

Modified date: 01 May 2018


Translate this page: