IBM Support

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

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error 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.
    

Local fix

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                                             *
    ****************************************************************
    

Problem conclusion

  • in v97fp5,ADM4500W  will logged as WARNING in the Windows Event
    logs
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC74888

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-03-07

  • Closed date

    2011-12-17

  • Last modified date

    2011-12-17

  • APAR is sysrouted FROM one or more of the following:

    IC74861

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC74888

Modified date: 17 December 2011