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 IC75736 Status: Geschlossen

PACKAGE CACHE OVERFLOW WHEN STATEMENT MONITOR SWITCH IS ON

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
With the Statement Monitor switch is on, the following "Package 
Cache Overflow" message in the db2diag.log may be seen 
 
many times: 
 
xxxx-xx-xx-xx.xx.xx.xxxxxx+xxx xxxxxxxxxxxxxx     LEVEL: Event 
PID     : xxxxxxx              TID  : xxxxx       PROC : db2sysc 
0 
INSTANCE: db2             NODE : 000         DB   : SAMPLE 
APPHDL  : 0-xxxxx              APPID: 
xx.xxx.xxx.xx.xxxxx.xxxxxxxxxxx 
AUTHID  : xxxxxxxx 
 
EDUID   : xxxxx                EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, access plan manager, sqlra_cache_mem_please, 
probe:100 
MESSAGE : ADM4500W  A package cache overflow condition has 
occurred. There is 
          no error but this indicates that the package cache has 
exceeded the 
          configured maximum size. If this condition persists, 
you should 
          perform additional monitoring to determine if you need 
to change the 
          PCKCACHESZ DB configuration parameter. You could also 
set it to 
          AUTOMATIC. 
REPORT  : APM : Package Cache : info 
IMPACT  : Unlikely 
DATA #1 : String, 274 bytes 
Package Cache Overflow 
memory needed             : 753 
current used size (OSS)   : 15984666 
maximum cache size (APM)  : 15892480 
maximum logical size (OSS): 40164894 
maximum used size (OSS)   : 48562176 
owned size (OSS)          : 26017792 
number of overflows       : xxxxx 
 
these may be followed by corresponding 
"Package Cache Overflow #xxxxx Resolved" messages. 
 
At some point the Package Cache Overflow state may persist 
(i.e. a "Package Cache Overflow" without a following 
"Package Cache Overflow Resolved" message). 
 
 
When the package cache overflows and particularly if the 
overflow state persists, then performance can degrade 
significantly and out of memory errors can occur.
Problem-Zusammenfassung:
Fixed
Local-Fix:
Turn off Statement Monitor Switch (DFT_MON_STMT) as workaround.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Fixed
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC76097 IC76098 IC76099 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
12.04.2011
16.12.2011
15.06.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
9.7.0.5 FixList