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

Obtain the fix for this APAR.

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 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.