DB2 FOR LUW / DB2FORLUW / 910 - DB2

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.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error description field for more information.            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to 9.7 with Fixpack including IC70305.               * 
****************************************************************

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.

The problem will be fixed in 9.7 with IC70305.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

11.08.2010
23.08.2010
23.08.2010

9.7.