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 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
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList