DB2 - Problembeschreibung
Problem IT03340 | Status: Geschlossen |
When PCKCACHESZ parameter is set to a value > 524288, the package cache will be cleaned too aggressively. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
When we set package cache size to a value larger than 524288 pages, the package cache will be cleaned too aggressively, with almost no entries retained. When checking the output from db2pd -dynamic, we will see results similar to the following. We will see a large "Total Heap Size", but small "Current Memory Used" and only a small "Number of Statements" in the cache. db2pd -dynamic: Current Memory Used 947264 Total Heap Size 2383872000 Cache Overflow Flag 0 Number of References 149 Number of Statement Inserts 149 Number of Statement Deletes 121 Number of Variation Inserts 149 Number of Statements 28 This APAR should resolve the above observed issue. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.5 Fix Pack 4. * **************************************************************** | |
Local-Fix: | |
set PCKCACHESZ to a value <= 524288 pages | |
verfügbare FixPacks: | |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 Version 10.5 Fix Pack 4. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 23.07.2014 06.11.2014 06.11.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.4 |