IBM Support

PI45714: ABEND0C4 RC00000004 DSNXOD3 +15E8 WITH UNION ALL FOR QUERY OFFLOADED TO IDAA

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DUMP TITLE=xxx,ABND=0C4-00000004,U=uuuu  ,M=C  ,C=111.LOCN=:
    :yyy.24.14.12     ,LOC=DSNXGRDS.DSNXOD3 +15E8
    Keywords:
    IDAAV4R1/K
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 for z/OS who use EXPLAIN.   *
    ****************************************************************
    * PROBLEM DESCRIPTION: An ABEND0C4 reason 00000004 in          *
    *                      DSNXOD3 +15E8 can occur for EXPLAIN     *
    *                      of certain SQL statements when query    *
    *                      acceleration is considered.             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    An ABEND0C4 reason 00000004 in DSNXOD3+15E8 can occur for
    EXPLAIN of certain SQL statements when query acceleration is
    considered. The abend can occur for SQL statements that
    go through UNION distribution. Query acceleration is
    considered when:
    (1) subsystem parameter ACCEL=COMMAND or AUTO and
        QUERY ACCELERATION = ENABLE, ENABLE WITH FAILBACK, ELIGIBLE
        or ALL; OR
    (2) subsystem parameter ACCELMODEL=YES.
    
    Keywords:
    IDAAV4R1/K ABENCD0C4 SQLEXPLAIN SQLUNION
    

Problem conclusion

  • DB2 code is fixed so that the EXPLAIN executes successfully.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI45714

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-07-27

  • Closed date

    2015-09-10

  • Last modified date

    2015-12-02

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

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

    UI31039 UI31040

Modules/Macros

  •    DSNXODML
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI31039

       UP15/11/06 P F511

  • RB10 PSY UI31040

       UP15/11/06 P F511

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

Modified date: 02 December 2015


Translate this page: