IBM Support

PI45501: ABEND04E RC00E70005 DSNXEFDA:M500 CAN OCCUR WHEN TRYING TO EXPLAIN AN SQL STATEMENT

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • ABEND04E RC00E70005 in DSNXEFDA:M500 can occur when trying to
    explain an sql statement.  The query is short-running
    and should not be offloaded at all.                   (d178729)
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 10 for z/OS who have        *
    *                 applied PI39061/UI28799 and use EXPLAIN or   *
    *                 have subsystem parameter ACCELMODEL set to   *
    *                 YES.                                         *
    ****************************************************************
    * PROBLEM DESCRIPTION: After PI39061/UI28799 is applied,       *
    *                      there is the potential for the          *
    *                      following abends:                       *
    *                       - ABEND04E RC00E70005 in               *
    *                         DSNXEFDA:M500 occurs for EXPLAIN of  *
    *                         an SQL statement.                    *
    *                       - When subsystem parameter ACCELMODEL  *
    *                         is YES, the following DB2 abends     *
    *                         possible when the FROM clause        *
    *                         specifies a                          *
    *                         data-change-table-reference:         *
    *                         (1) ABEND0C4 RC00000038 in           *
    *                         DSNIBNRF+0AB2                        *
    *                         (2) ABEND0C4 RC00000038 in           *
    *                         DSNISRTI+4C50                        *
    *                         For this problem other abends are    *
    *                         possible.                            *
    ****************************************************************
    * RECOMMENDATION: Apply the corrective PTF when it is          *
    *                 available.                                   *
    ****************************************************************
    After PI39061 / UI28799 is applied, there is a potential for
    the following abends:
     - ABEND04E RC00E70005 in DSNXEFDA :M500 to occur for EXPLAIN
       of an SQL statement or when using BIND option
       EXPLAIN(YES/ONLY) when an invalid pointer is used and
       garbage data is picked up.
     - When subsystem parameter ACCELMODEL is YES, the following
       abends are possible when the FROM clause specifies a
       data-change-table-reference:
        (1) ABEND0C4 RC00000038 in DSNIBNRF+0AB2
        (2) ABEND0C4 RC00000038 in DSNISRTI+4C50
       For this problem other abends are possible. Also a REBIND
       is necessary after applying this PTF.
    
    Keywords:
    ABEND04E ABEND0C4 AB04E AB0C4 ACCELMODEL SQLEXPLAIN IDAAV4R1/K
    SQLSELWDELETE SQLSELWINSERT SQLSELWMERGE SQLSELWUPDATE FINAL
    OLD
    

Problem conclusion

  • DB2 code is fixed so that the previously described abends in
    the scenarios above do not occur.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI45501

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    YesPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-07-22

  • Closed date

    2015-08-21

  • Last modified date

    2015-10-02

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

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

    UI30438

Modules/Macros

  •    DSNXODML DSNXOIN  DSNXONZO
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI30438

       UP15/09/09 P F509

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

Reference #: PI45501

Modified date: 02 October 2015


Translate this page: