IBM Support

PI46386: A USER CANCEL DURING LONG CACHE PREPARE CAN RESULT IN ABEND04E WITH VARIOUS MODULES AND REASON CODES

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A user cancel during long cache prepare can result in 04E abends
    with various modules and reason codes, including but not limited
    to:
    RC00C90101 in DSNGEPDL
    RC00E70005 in DSNXEIST :P012
    RC00E70005 in DSN          :P000
    this only happens if the cancel occurs in a small timing window.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: DB2 10 and 11 for z/OS users who issue       *
    *                 cancel during PREPARE of dynamic SQL         *
    ****************************************************************
    * PROBLEM DESCRIPTION: A user cancel during full cache prepare *
    *                      can result in abends with various       *
    *                      locations and reason codes, including   *
    *                      but not limited to:                     *
    *                      RC00C90101 in DSNGEPDL                  *
    *                      RC00E70005 in DSNXEIST P012             *
    *                      RC00E70005 in DSN      P000             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    A small timing window exists after storing the SQL statement in
    the cache and disabling the recovery routine.  If a cancel
    occurs within this window, the dependency records are freed with
    the assumption the SQL failed to get cached.  Since the SQL did
    get cached, the SQL can execute without the protection of the
    dependency records and will point to freed storage.
    

Problem conclusion

  • If a cancel occurs in this window, the SQL statement will be
    marked invalid so that any attempt to execute it will cause it
    to be re-prepared.
    
    Additional Keywords: ABEND04E SQLDYNSTMTCACHE
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI46386

  • 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

    2015-08-05

  • Closed date

    2015-09-30

  • Last modified date

    2015-11-04

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

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

    UI31644 UI31645

Modules/Macros

  • DSNXEDS1
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI31644

       UP15/10/15 P F510

  • RB10 PSY UI31645

       UP15/10/15 P F510

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
04 November 2015