PK76284: ABEND04E-00E20003,U=XXX ,M=(N),C=810.LOCN=XX.XX.XX.XX ,LOC=DSNGEPLC.DSNSVBK +0602

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E-00E20003 DSNSVBK +0602e
  Excessive storage consumption by not deallocating CUR blocks.
  .
  DB2STGLK/K
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 users who use materialized query     *
  *                 tables (MQT) for automatic query rewrite     *
  *                 and one of the following:                    *
  *                                                              *
  *                   1. the DECLARE CURSOR statement and        *
  *                      dynamic statement cache                 *
  *                                                              *
  *                   2. block fetch when query base tables that *
  *                      are referenced in the MQT definition    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When materialized query tables (MQT)    *
  *                      are used for automatic query rewrite,   *
  *                      the following symptoms may occur:       *
  *                                                              *
  *                        1. ABEND04E-00E20003 at LOC=DSNGEPLC. *
  *                           DSNSVBK+0602 may occur if the      *
  *                           DECLARE CURSOR statement and       *
  *                           dynamic statement cache are used.  *
  *                                                              *
  *                        2. Block fetch may be disabled when   *
  *                           query the base tables that are     *
  *                           referenced in the MQT definition.  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When materialized query tables (MQT) are used for automatic
  query rewrite, the following symptoms may occur:
  
    1. ABEND04E-00E20003 at LOC=DSNGEPLC.DSNSVBK+0602 may occur
       if the DECLARE CURSOR statement and dynamic statement
       cache are used.
  
    2. Block fetch may be disabled when query the base tables
       that are referenced in the MQT definition.
  
  During the MQT query rewrite process, DB2 loses the track of
  the storage which holds the cursor information when dynamic
  statement cache is in effect. As the result, the storage is
  not freed. Later on it may lead to storage shortage and cause
  an 04E abend in DSNSVBK.
  
  During the MQT query rewrite process, DB2 fails to enable
  the block fetch capability. As the consequence, when the base
  tables are queried, it yields to a poor throughput. Notice that
  those base tables are referenced in the MQT definition.
  

Problem conclusion

• DB2 is modified to ensure the storage as described in the
  above scenario is freed.
  
  DB2 is modified to ensure the block fetch as described in the
  above scenario is enabled.
  
  Additional keywords: ABEND04E SQLMQT SQLCACHE SQLBLOCKFETCH
                       SQLCURSOR SQLSTORAGELEAK SQLPERFORMANCE
                       SQLSTROAGEFREE SQLQUERYREWRITE
  

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:

  UK42908 UK42909

Modules/Macros

• DSNXODML
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK42908

     UP09/01/22 P F901

• R910 PSY UK42909

     UP09/01/22 P F901

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.