DB2 FOR LUW / DB2FORLUW / 950 - DB2

When a bufferpool is resized from something relatively small to 
something noticeably larger, the 'alter bufferpool' command will 
be met with SQL20189W, even with sufficient memory resources 
available. 
If the exact command is repeated a second time, it will succeed 
without any warning message reported. 
 
Reproduce Steps : 
The problem can be reproduced by taking a small-size bufferpool 
and resizing it to something significantly larger. For instance: 
> db2start 
> db2 create db mydb 
> db2 connect to mydb 
> db2 create bufferpool mypool size 100 pagesize 8192 
> db2 alter bufferpool mypool size 1966080 [This will receive a 
warning] 
(Note: Please make sure you have enough memory resources to 
support the bufferpool resize) 
> db2 alter bufferpool mypool size 1966080 [This will succeed 
without any warning]

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error description field for more information.            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.5 Fix Pack 8.                           * 
****************************************************************

Issue the alter bufferpool command again.

DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem was first fixed in DB2 Version 9.5 Fix Pack 8.

keiner bekannt / siehe Local-Fix

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

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

20.02.2011
27.06.2011
27.06.2011

9.5.FP8