DB2 - Problembeschreibung
Problem IT00336 | Status: Geschlossen |
STMM MAY UNNECESSARILY INCREASE PACKAGE CACHE SIZE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * systems with self-tuning (STMM) of package cache enabled * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 Fix Pack <n> * **************************************************************** | |
Local-Fix: | |
use manual tuning of package cache | |
Lösung | |
Problem first fixed in DB2 Version 9.7 Fix Pack 10 | |
Workaround | |
see Local Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 18.03.2014 11.11.2014 11.11.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP<n&, 9.7.FP10 | |
Problem behoben lt. FixList in der Version | |
9.7.0.10 |