Latest versionsfixlist
11.1.0.6 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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

DB2 - Problem description

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 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.