home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC66955 Status: Geschlossen

CONTROLCENTER DOES NOT SHOW THE PENDING VALUE FOR APPL_MEMORY AS AUTOMATIC
VALUE

Produkt:
DB2 FOR LUW / DB2FORLUW / 980 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* 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:
verfügbare FixPacks:
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

Lösung
Problem was first fixed in Version 9.8 FixPack 3
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
08.03.2010
26.12.2010
26.12.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.8.FP3
Problem behoben lt. FixList in der Version
9.8.0.3 FixList