DB2 FOR LUW / DB2FORLUW / 970 - 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 Version 9.7 FixPack 4.                            * 
****************************************************************

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.

DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem was first fixed in DB2 UDB Version 9.7 FixPack 4.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC70520 IC70521 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

30.07.2010
12.05.2011
12.05.2011

9.7.FP4