DB2 - Problem description
Problem IC64801 | Status: Closed |
CONTROLCENTER DOES NOT SHOW THE PENDING VALUE FOR APPL_MEMORY AS AUTOMATIC VALUE | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - 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 * * CLPregardingAPPL_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 selectConfigure Parameters menu.The pending * * value for APPL_MEMORY shows notAUTOMATIC(10000)but 10000.The * * CLP command "get db cfg" shows AUTOMATIC(10000).Control * * Center shows the pending value as follows:keyword, value, * * pending valueAPPL_MEMORY, AUTOMATIC(10016), 10000The get * * db cfg show detail command shows as follows:Application * * Memory Size * * (4KB),(APPL_MEMORY)=AUTOMATIC(10016),AUTOMATIC(10000) * **************************************************************** * RECOMMENDATION: * * Upgrade to V9.7 FP2 * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Solution | |
Problem was first fixed in V9.7 FP2 | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC66955 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.11.2009 08.07.2010 08.07.2010 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP2 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.2 |