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 IC70520 Status: Geschlossen

WHEN ALTERING BUFFERPOOL TO FIXED SIZE FROM AUTOMATIC IS DEFERRED,
STMM WILL CONTINUE TO TUNE IT.

Produkt:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problembeschreibung:
A user-initiated alter of an automatic bufferpool will be 
deferred until the next database activation if there is not 
enough memory to satisfy this request or "deferred" option is 
specified explicitly. Such a deferred request will be forgotten 
if STMM decides to alter the same bufferpool before the next 
database activation. The problem is that STMM continues to tune 
this bufferpool, and changes made by STMM will override any 
previously deferred (hence saved) alter requests.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error description field for more information.            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to 9.7 with Fixpack including IC70305.               * 
****************************************************************
Local-Fix:
1) Try to issue an alter request that will likely be not 
deferred, for example altering to the same size will not get 
deferred, but the bufferpool will no longer be tuned by STMM. 
2) If the request does gets deferred while the bufferpool is 
still automatic, deactivate and reactivate the database before 
STMM gets a chance to tune the bufferpool.
Lösung
The problem will be fixed in 9.7 with IC70305.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
11.08.2010
23.08.2010
23.08.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.
Problem behoben lt. FixList in der Version