如何正确更改缓冲池大小？ [英] how to change the bufferpool size correctly?
问题描述
我们在windows上使用db2 udb v8.1，通常我会使用control
center更改缓冲池大小，因为我知道更改将是
效果立即为版本8.1，所以我右键单击缓冲池，执行
更改，更改大小（更小的一个），之后，我使用
配置参数来检查缓冲池大小，它仍显示旧值，我关闭控制中心并重新打开，仍然相同，
所以我必须停止实例才能选择正确的
值？
we are using db2 udb v8.1 on windows, normally i would use control
center to change bufferpool size since i know the change will be
effect immediately for version 8.1, so i right click bufferpool, do
alter, change the size (to a smaller one), after that , i use the
configuration parameter to check the bufferpool size, it still show
the old value, i close the control center and reopen , still the same,
so is that i must stop the instance in order to pick up the right
value?
推荐答案
缓冲池更改直到有时才会生效没有
有效连接。控制中心是否有刷新选项？
xixi写道：
A bufferpool change won''t take effect until a time when there are no
active connections. Is there a refresh option in the Control Center?
xixi wrote:
我们在windows上使用db2 udb v8.1，通常情况下我会使用控制中心来改变缓冲池大小，因为我知道版本8.1的更改会立即生效，所以我右键单击缓冲池，做
改变，改变大小（到一个较小的一个），之后，我使用
配置参数来检查缓冲池大小，它仍然显示旧值，我关闭控制中心并重新打开，仍然相同，
所以是我必须停止实例才能获得正确的值？
we are using db2 udb v8.1 on windows, normally i would use control
center to change bufferpool size since i know the change will be
effect immediately for version 8.1, so i right click bufferpool, do
alter, change the size (to a smaller one), after that , i use the
configuration parameter to check the bufferpool size, it still show
the old value, i close the control center and reopen , still the same,
so is that i must stop the instance in order to pick up the right
value?
缓冲池更改不会生效直到没有
活动连接的时间。控制中心是否有刷新选项？
xixi写道：
A bufferpool change won''t take effect until a time when there are no
active connections. Is there a refresh option in the Control Center?
xixi wrote:
我们在windows上使用db2 udb v8.1，通常情况下我会使用控制中心来改变缓冲池大小，因为我知道版本8.1的更改会立即生效，所以我右键单击缓冲池，做
改变，改变大小（到一个较小的一个），之后，我使用
配置参数来检查缓冲池大小，它仍然显示旧值，我关闭控制中心并重新打开，仍然相同，
所以是我必须停止实例才能获得正确的值？
we are using db2 udb v8.1 on windows, normally i would use control
center to change bufferpool size since i know the change will be
effect immediately for version 8.1, so i right click bufferpool, do
alter, change the size (to a smaller one), after that , i use the
configuration parameter to check the bufferpool size, it still show
the old value, i close the control center and reopen , still the same,
so is that i must stop the instance in order to pick up the right
value?
Blair Adamache< ba ** *****@2muchspam.yahoo.com>在消息新闻中写道：< c6 ********** @ hanover.torolab.ibm.com> ...
Blair Adamache <ba*******@2muchspam.yahoo.com> wrote in message news:<c6**********@hanover.torolab.ibm.com>...
缓冲池更改直到一段时间才会生效当没有
活动连接时。控制中心是否有刷新选项？
A bufferpool change won''t take effect until a time when there are no
active connections. Is there a refresh option in the Control Center?
严格来说不是真的。除非另有说明，否则缓冲池大小的更改默认为IMMEDIATE
，或者（在大小增加的情况下）db
共享集不大足以包含新的大小。
Not strictly true. Changes to the size of a buffer pool default to being IMMEDIATE
unless otherwise specified, or (in the case of an increase in size), the db
shared set isnt big enough to contain the new size.
我们在windows上使用db2 udb v8.1，通常我会使用control
center更改缓冲池大小，因为我知道更改将立即对版本8.1产生影响，所以我右键单击缓冲池，执行
更改，更改大小（更小的一个），之后，我使用
配置参数检查缓冲池大小，它仍然显示旧值，我关闭控制中心并重新打开，仍然相同，所以是我必须停止实例才能选择正确的值？
we are using db2 udb v8.1 on windows, normally i would use control
center to change bufferpool size since i know the change will be
effect immediately for version 8.1, so i right click bufferpool, do
alter, change the size (to a smaller one), after that , i use the
configuration parameter to check the bufferpool size, it still show
the old value, i close the control center and reopen , still the same,
so is that i must stop the instance in order to pick up the right
value?
您参考''配置参数'' - 我认为您正在寻找
BUFFPAGE值的
？这不会改变 - 你没有修改它。 BUFFPAGE
仅影响大小为-1的缓冲池。请参阅文档
了解更多信息
hj
You make reference to ''configuration parameter'' - I presume that you are looking
at the value of BUFFPAGE? This wouldnt change - you havent modified it. BUFFPAGE
only affects buffer pools which have a size listed of -1. See the documentation
for more information
hj
这篇关于如何正确更改缓冲池大小？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
