IBM Support

PM54498: ABEND04E RC00E20003 IN DSNSVSTK +05B8 OFFSET05B8 MAY OCCUR WITH DSNXOPPD AS THE CALLER REQUESTING STORAGE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • ABEND04E RC00E20003 IN DSNSVSTK +05B8 OFFSET05B8 MAY OCCUR WITH
    DSNXOPPD AS THE CALLER REQUESTING STORAGE
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 for z/OS queries with a     *
    *                 combination of many OR and AND predicates    *
    *                 on objects in a partitioned table space.     *
    ****************************************************************
    * PROBLEM DESCRIPTION: THE PROBLEM THIS FIX ADDRESSES HAS THE  *
    *                      FOLLOWING SYMPTOMS:                     *
    *                                                              *
    *                       ABEND04E RC00E20003                    *
    *                         CSECT DSNSVSTK  OFFSET05B8           *
    *                                                              *
    *                       ABEND04E RC00E20003                    *
    *                         CSECT DSNSVBK  OFFSET0602            *
    *                                                              *
    *                       ABEND04E RC00E20018                    *
    *                         CSECT DSNSTKGG OFFSET0CD2            *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                      PROBLEM SCENARIO:                       *
    *                                                              *
    *                      The abend may occur with DSNXOPPD as    *
    *                      the caller requesting storage for       *
    *                      queries with a combination of many OR   *
    *                      and AND predicates on objects in a      *
    *                      partitioned table space.                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    SUMMARY OF DB2 EVENTS:
    
    Storage is being used inefficiently, leading to a storage
    shortage when access paths are being determined for such
    complex queries.
    

Problem conclusion

  • Code is changed to use storage more efficiently when determining
    access paths for queries with a combination of many OR and AND
    predicates.
    
    
    ADDITIONAL KEYWORDS:
    SQLACCESSPATH SQLSTORAGE DB2STGLK/K SQLOR SQLAND
    

Temporary fix

  • *********
    * HIPER *
    *********
    

Comments

APAR Information

  • APAR number

    PM54498

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-12-15

  • Closed date

    2012-02-08

  • Last modified date

    2012-03-01

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

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

    UK76033

Modules/Macros

  • DSNXOPPD
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK76033

       UP12/02/24 P F202

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:
01 March 2012