Latest versionsfixlist
11.1.0.6 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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

DB2 - Problem description

Problem IC76098 Status: Closed

PACKAGE CACHE OVERFLOW WHEN STATEMENT MONITOR SWITCH IS ON

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
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 Summary:
Fixed in v9.5 FP 9.
Local Fix:
Turn off Statement Monitor Switch (DFT_MON_STMT) as workaround.
available fix packs:
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Fixed in v9.5 FP 9.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
01.05.2011
08.03.2012
08.03.2012
Problem solved at the following versions (IBM BugInfos)
9.5.FP9
Problem solved according to the fixlist(s) of the following version(s)
9.5.0.9 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.