|
Problem IC74604
|
Status: Closed |
INCREASING BUFFERPOOL WILL GET SQL20189W EVEN THOUGH THERE IS ENOUGH MEMORY TO SATISFY THE RESIZE REQUEST. |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
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] |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error description field for more information. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Version 9.5 Fix Pack 8. *
**************************************************************** |
| Local Fix: |
Issue the alter bufferpool command again. |
| available fix packs: |
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
|
| Solution |
Problem was first fixed in DB2 Version 9.5 Fix Pack 8. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC75646
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 20.02.2011
27.06.2011
27.06.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.8
|
 |
