|
Problem IC74888
|
Status: Closed |
ADM4500W - PACKAGE CACHE OVERFLOW MESSAGE GETS LOGGED AS ERROR IN WINDOWS EVENT LOGS. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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: *
* 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. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v97f5 *
**************************************************************** |
| Local Fix: |
|
| 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 |
in v97fp5,ADM4500W will logged as WARNING in the Windows Event
logs |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 07.03.2011
17.12.2011
17.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.F5,
9.7.FP5,ADM4,
9.7.FP5,ADM4500W
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
