DB2 FOR LUW / DB2FORLUW / 970 - DB2

Package cache may be growing with increased number of statement 
entries and decreased numbers of variations if statement 
concentrator is enabled on a database. Performance degradation 
would be observed once package cache becomes full due to the 
increased number of statement entries. 
 
Users can identify if he/she is hitting this problem. 
 
- Statement concentrator is enebled on the databaes. i.e. 
STMT_CONC is set as LITERALS. 
- The number of statement entries in the package cache after 
running FLUSH PACKAGE CACHE keeps growing. 
  i.e. the following number keeps growing on the database. 
 db2 connect to <dbname> 
 db2 flush package cache dynamic 
 db2pd -db <dbname> -dyn | grep "^Number of Statements" 
- Small number of variations in comparison with number of 
statements remains in package cache. 
 
This problem is caused by a timing hole on deleting statement 
entries from package cache.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users who use statement concentrator.                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to V9.7 FixPack 7 or later.                   * 
****************************************************************

Please set STMT_CONC as OFF.

DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

This problem was first fixed in DB2 V9.7 FixPack 7.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC88608 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

22.04.2012
31.12.2012
31.12.2012

9.7.FP7