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 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
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux

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 FixList