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 IC74861 Status: Closed

ADM4500W - PACKAGE CACHE OVERFLOW MESSAGE GETS LOGGED AS ERROR IN WINDOWS
EVENT LOGS.

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
Starting from DB2 V95, a package cache overflow warning message 
gets logged in as ERROR in Windows Event logs as follows. 
 
Event Type: Error 
Event Source: DB2-0 
Event Category: None 
Event ID: 4 
Date: 21.02.2011 
Time: 08:00:02 
User: N/A 
Computer: S-BDB02 
Description: 
2011-02-21-08.00.02.327007 Instance:DB2 Node:000 
PID:5716(db2syscs.exe) TID:200 Appid:*LOCAL.DB2.110221072654 
access plan manager sqlra_cache_mem_please Probe:100 
Database:VUINDEX 
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. 
 
It should get logged in as WARNING in the Windows Event logs.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* ADM4500W - PACKAGE CACHE OVERFLOW MESSAGE GETS LOGGED AS     * 
* ERROR                                                        * 
* IN WINDOWS EVENT LOGS.                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v95fp8                                            * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
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
After fix: ADM4500W - PACKAGE CACHE OVERFLOW MESSAGE GETS LOGGED 
AS WARNING 
IN WINDOWS EVENT LOGS.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC74888 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
04.03.2011
05.07.2011
05.07.2011
Problem solved at the following versions (IBM BugInfos)
9.5.FP8
Problem solved according to the fixlist(s) of the following version(s)
9.5.0.8 FixList