DB2 FOR LUW / DB2FORLUW / A10 - 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 V10.1 FixPack 2 or later.                  * 
****************************************************************

Please set STMT_CONC as OFF.

DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

This problem was first fixed in DB2 V10.1 FixPack 2.

keiner bekannt / siehe Local-Fix

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

27.11.2012
31.12.2012
31.12.2012