Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC75736 Status: Closed

PACKAGE CACHE OVERFLOW WHEN STATEMENT MONITOR SWITCH IS ON

product:
DB2 FOR LUW / DB2FORLUW / 970 - 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
Local Fix:
Turn off Statement Monitor Switch (DFT_MON_STMT) as workaround.
available fix packs:
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

Solution
Fixed
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC76097 IC76098 IC76099 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
12.04.2011
16.12.2011
15.06.2012
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.5 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.