IBM Support

PI26089: ACCELERATED QUERY GET ABEND04E RC00E70005 IN DSNXONZS M165 WITH TIMESTAMPDIFF IN A VIEW

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Accelerated query terminate with abend04e rc00E70005 in
    DSNXONZS M165 when when TIMESTAMPDIFF is used in a VIEW.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 for z/OS who use            *
    *                 query acceleration.                          *
    ****************************************************************
    * PROBLEM DESCRIPTION: An ABEND04E RC00E70005 DSNXONZS M165    *
    *                      occurs for a statement that is          *
    *                      executed on an accelerator when the     *
    *                      statement references a view and the     *
    *                      view uses the scalar function           *
    *                      TIMESTAMPDIFF.                          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    An ABEND04E RC00E70005 DSNXONZS M165 occurs for a statement
    that is executed on an accelerator when the statement
    references a view and the view uses the scalar function
    TIMESTAMPDIFF.
    
    For static SQL queries that have been bound for acceleration
    and fit the above criteria, after applying
    this PTF, REBIND the package for the failing query.
    
    Keywords:
    IDAAV3R1/K IDAAV4R1/K ABEND04E SQLTIMESTAMPDIFF VIEW
    

Problem conclusion

  • DB2 is fixed so that the query executes properly on an
    accelerator.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI26089

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-09-19

  • Closed date

    2014-10-13

  • Last modified date

    2014-11-04

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

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

    UI22157 UI22158

Modules/Macros

  •    DSNXONZS
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI22157

       UP14/10/29 P F410

  • RB10 PSY UI22158

       UP14/10/29 P F410

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

Modified date: 04 November 2014


Translate this page: