DB2 - Problem description
Problem IC66955 | Status: Closed |
CONTROLCENTER DOES NOT SHOW THE PENDING VALUE FOR APPL_MEMORY AS AUTOMATIC VALUE | |
product: | |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 | |
Problem description: | |
There is a difference between ControlCenter and CLP regarding APPL_MEMORY parameter. The repro steps using db2sampl(SAMPLE DB) is as follows: 1. show database name SAMPLE on left window. 2. select SAMPLE DB and click right mouse button and select Configure Parameters menu. The pending value for APPL_MEMORY shows not AUTOMATIC(10000) but 10000. The CLP command "get db cfg" shows AUTOMATIC(10000). . Control Center shows the pending value as follows: keyword value pending value APPL_MEMORY AUTOMATIC(10016) 10000 . The get db cfg show detail command shows as follows: Application Memory Size (4KB) (APPL_MEMORY) = AUTOMATIC(10016) AUTOMATIC(10000) | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ControlCenter users * **************************************************************** * PROBLEM DESCRIPTION: * * There is a difference between ControlCenter and CLP * * regarding * * APPL_MEMORY parameter. * * * * * * * * The repro steps using db2sampl(SAMPLE DB) is as follows: * * * * * * * * 1. show database name SAMPLE on left window. * * * * 2. select SAMPLE DB and click right mouse button and select * * * * Configure Parameters menu. * * * * * * * * The pending value for APPL_MEMORY shows not AUTOMATIC(10000) * * but * * 10000. * * * * The CLP command "get db cfg" shows AUTOMATIC(10000). * * * * * * * * . * * * * * * * * Control Center shows the pending value as follows: * * * * * * * * keyword value * * pending * * value * * * * * * * * APPL_MEMORY AUTOMATIC(10016) 10000 * * * * * * * * * * * * . * * * * * * * * The get db cfg show detail command shows as follows: * * * * Application Memory Size (4KB) (APPL_MEMORY) = * * * * AUTOMATIC(10016) AUTOMATIC(10000) * **************************************************************** * RECOMMENDATION: * * Upgrade to UDB Version 9.8 FixPack 3 * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.8 Fix Pack 3 for Linux, UNIX, and Windows | |
Solution | |
Problem was first fixed in Version 9.8 FixPack 3 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 08.03.2010 26.12.2010 26.12.2010 |
Problem solved at the following versions (IBM BugInfos) | |
9.8.FP3 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.8.0.3 |