|
Problem IT00363
|
Status: Closed |
STMM MAY UNNECESSARILY INCREASE PACKAGE CACHE SIZE |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
STMM may incorrectly calculate performance benefits for package
cache when statements are invalidated. For example, cached
statements may be invalidated because of dependencies on dropped
objects, and when those statements are executed again -
necessitating recompilation, STMM may incorrectly calculate the
compilation could be avoided with a larger package cache.
The most obvious sign of this is that STMM increase the package
cache configured size before it is reached. This can be seen by
comparing the logical usage high water mark in db2pd -db
<database> -mempools against its configured size (current
PCKCACHESZ setting, or the "configured size" from db2pd -db
<database> -mempools on Version 10.1 and higher). |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* systems using STMM to tune package cache *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.1 Fix Pack 5 *
**************************************************************** |
| Local Fix: |
use manual tuning of package cache |
| Solution |
Problem first fixed in DB2 Version 10.1 Fix Pack 5 |
| Workaround |
see Local Fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.03.2014
14.07.2015
14.07.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.5
|
 |
