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