PM77114: ABEND04E RC00E70005 DSNXEIST +0F86

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • ABEND04E RC00E70005 DSNXEIST OFFEST0F86  due to a mismatching
    DMHE token during a SHTE LRU process .
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: DB2 10 for z/OS users of PREPARE statements  *
    *                 with DB2 Dynamic Statement Cache and         *
    *                 IFCID 316 or class 29 monitor trace.         *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND04E RC00E70005                     *
    *                      at DSNXGRDS . DSNXEIST +F82             *
    *                      on a Dynamic Statement Cache            *
    *                      LONG PREPARE.                           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When DB2 Dynamic Statement Cache (DSC) is active, the DSC LONG
    PREPARE process inserts the dynamically PREPARed statement
    in the global cache. When there is not enough space to insert
    a new statement, DB2 drives the LRU process to remove an old
    statement in the cache to have space for the new statement.
    
    When a statement is being removed from the cache, DB2 may write
    the IFCID 316 trace record. While tracing the IFCID 316 record,
    an SQLCODE can occur (such as a conversion error). This negative
    SQLCODE can affect the LONG PREPARE process of a new
    statement, which results in undoing the PREPARE of
    the statement. However, this statement is still advertently
    inserted in the cache without valid dependency information.
    The internal control block of the dependency information
    can be reused for another cached statement later. This
    inconsistency is detected on a subsequent statement invalidation
    process resulting in the reported abend.
    

Problem conclusion

  • DB2 code has been modified to not insert a statement
    in the cache, if an error was hit during the LRU
    process.
    
    RELATED KEYWORDS: 04E AB04E IFCID316 0316 OFFSETF82
                      STMTCACHE SQLDYNSTMTCACHE
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM77114

  • 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

    2012-11-14

  • Closed date

    2013-02-11

  • Last modified date

    2013-03-04

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

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

    UK91560

Modules/Macros

  •    DSNGEGBK DSNGEPIS DSNXEDS1 DSNXESX
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK91560

       UP13/02/27 P F302

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.



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM77114

Modified date:

2013-03-04

Translate my page

Machine Translation

Content navigation