IBM Support

PI39542: ABEND04E RC00E70005 IN DSNXOV0 :M101 CAN OCCUR ON BIND/PREPARE OF A QUERY REFERENCING A VIEW 15/04/30 PTF PECHANGE

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 DSNXOV0 :M101 can occur on bind/prepare
    of a query referencing a view that was bound after PI30859/
    UI26382 was applied.
                                                          (d177403)
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 10 for z/OS who have        *
    *                 applied PI30859/UI26382 and who:             *
    *                 (1) Use views created in DB2 for             *
    *                     z/OS V8 or later.                        *
    *                 Or,                                          *
    *                 (2) Use query acceleration and have          *
    *                     an accelerated query with the            *
    *                     converted accelerated query text         *
    *                     longer than 32K bytes.                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: After PI30859/UI26382 is applied,       *
    *                      the following issues may occur:         *
    *                      (1) during BIND or PREPARE time an      *
    *                          ABEND04E RC00E70005 in DSNXOV0:M101 *
    *                          may occur for an SQL statement that *
    *                          references a view created in        *
    *                          DB2 for z/OS V8 or later.           *
    *                      (2) With PTF for IBM DB2 Analytics      *
    *                          Accelerator APAR PI30282 applied,   *
    *                          SQLCODE -725 may occur when         *
    *                          executing an accelerated query with *
    *                          converted statement text longer     *
    *                          than 32K bytes.                     *
    ****************************************************************
    * RECOMMENDATION: Apply the corrective PTF when it is          *
    *                 available.                                   *
    ****************************************************************
    After PI30859/UI26382 is applied:
    (1) During BIND or PREPARE time, an ABEND04E RC00E70005 in
        DSNXOV0:M101 may occur for an SQL statement that references
        a view created in DB2 V8 or later.
    
    (2) With PTF for IBM DB2 Analytics Accelerator APAR PI30282
        applied, SQLCODE -725 may occur when executing an
        accelerated query with converted statement text longer
        than 32K bytes. This is caused by incorrect pointer
        assignment that causes incorrect serviceability texts
        to be propagated to the accelerator.
    
    Keywords:
    ABEND04E SQLVIEW IDAAV4R1/K
    

Problem conclusion

  • DB2 code is fixed so that the abend and SQLCODE -725
    as described in the scenarios above do not occur.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI39542

  • 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-04-21

  • Closed date

    2015-05-06

  • Last modified date

    2015-06-01

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

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

    UI27412

Modules/Macros

  •    DSNXEDS1 DSNXOV0
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI27412

       UP15/05/22 P F505

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

Modified date: 01 June 2015


Translate this page: