home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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 IC84561 Status: Closed

SPURIOUS PACKAGE CACHE OVERFLOWS REPORTED WHEN CACHE IS AT FULL UTILIZATION

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
Spurious Package cache overflows might be reported due to timing 
conditions which falsely trigger DB2 to think it has exceeded 
the configured size. 
 
The current used size hardly exceeds the maximum cache size at 
the time the overflow is reported and the overflow is also 
reported to be resolved straight away. Example: 
 
With PCKCACHESZ set to 40000 
 
2012-03-15-02.10.29.770037+060 E39763621A1173     LEVEL: Event 
PID     : xxx             TID  : xxx     PROC : db2sysc 0 
INSTANCE: xxxx            NODE : 000         DB   : xxxx 
APPHDL  : xxx             APPID: xxxx 
AUTHID  : xxx 
EDUID   : xxx              EDUNAME: db2agent (xxx) 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, 277 bytes 
Package Cache Overflow 
memory needed             : 376 
current used size (OSS)   : 158924904 
maximum cache size (APM)  : 158924800 
maximum logical size (OSS): 159116039 
maximum used size (OSS)   : 178520064 
owned size (OSS)          : 178520064 
number of overflows       : 218 
 
2012-03-15-02.10.29.794177+060 E39764795A747      LEVEL: Event 
PID     : xxx              TID  : xxx       PROC : db2sysc 0 
INSTANCE: xxx            NODE : 000         DB   : xxxx 
APPHDL  : xxx             APPID: xxxx 
AUTHID  : xxxx 
EDUID   : xxx             EDUNAME: db2agent (xxx) 0 
FUNCTION: DB2 UDB, access plan manager, sqlra_cache_mem_please, 
probe:200 
REPORT  : APM : Package Cache : info 
IMPACT  : Unlikely 
DATA #1 : String, 260 bytes 
Package Cache Overflow #218 Resolved. 
memory needed             : 251 
current used size (OSS)   : 158906248 
maximum cache size (APM)  : 158924800 
maximum logical size (OSS): 159116039 
maximum used size (OSS)   : 178520064 
owned size (OSS)          : 178520064 
 
 
These messages are not a reason for alarm. 
 
1. The overflow is  resolved within the sub-second. So space 
remains in the cache overall. 
 
2. The percentage of the overflow is minimal so we are not in 
danger of being out allocatable memory. 
 
 
This APAR will avoid these kind of messages in the db2diag.log 
which are reporting a false alarm.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Additional checking has been introduced to avoid spurious    * 
* overflow messages.                                           * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.1 and Fix Pack 1                   * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Solution
Problem was first fixed in DB2 version 10.1 and Fix Pack 1
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
14.06.2012
02.11.2012
02.11.2012
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.1 FixList
10.5.0.1 FixList