home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 10.5 Fix Pack 9 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 FixList