缓冲池大小的配置顾问 [英] configuration advisor on buffer pool size

问题描述

我们在windows上使用db2 udb v8.1，我尝试使用

配置顾问来获取有关参数设置的建议，首先是

，我给DB2的目标内存是80％的物理内存，它给了我一个关于缓冲池大小的建议，所以我接受了

的更改，稍后，我发现我给DB2提供了太多内存，所以

i将目标更低，但建议并没有相应地更改

缓冲池大小，为什么呢？谢谢

we are using db2 udb v8.1 on windows, i try to use the
configuration advisor to get recommendation on the parameter setting,
at first, i give the target memory for DB2 is 80% of the physical
memory, it gives me a recommendation on bufferpool size, so i accept
the change, later on , i found that i gave too much memory to DB2, so
i change the target lower, but the recommendation doesn''t change the
buffer pool size accordingly, why is that? thanks

推荐答案

西溪，我相信当你说它没有改变时，你仍然是看着价值的b $ b通过

控制中心中的COnfigure Parameters选项。

此应用程序打开时，会快照DB CFG并选择

值读取。当您运行Advisor输出时，您使用immediate或deferred选项更改实际的

文件，并且旧值仍然是缓存并显示的值。

如果使用控制中心的

db下拉列表中的Buffer Pools对象查看bp的大小，您应该会看到新值。如果

没有，只需刷新buffwer池对象。

或者，如果你不介意，只需关闭CC并重新打开它。转到

配置参数，你就可以看到你的新价值了。

HTH，皮埃尔。


xixi写道：

Xixi, I believe that when you say it does not change, you are still
looking at the value through the COnfigure Parameters option in the
COntrol Center.
This application, when it opens, snapshots the DB CFG and picks the
values it reads. When you run the Advisor output, you change the actual
file with the immediate or deferred option, and the old value is still
cached and displayed.
If you look at the size of the bp using the Buffer Pools object in the
db drop down on the control center you should see the new value. If
not, just refresh the the buffwer pool object.
Or, if you do not mind, just close the CC and reopen it. Go to the
Configure parameters and you shouyld see your new value.
HTH, Pierre.

xixi wrote:

我们在windows上使用db2 udb v8.1，我尝试使用
配置顾问来获取有关参数设置的建议，首先，我给出了目标内存对于DB2来说是80％的物理内存，它给我一个关于缓冲池大小的建议，所以我接受改变，后来，我发现我给了DB2太多的内存，所以缓冲池大小，为什么呢？谢谢

we are using db2 udb v8.1 on windows, i try to use the
configuration advisor to get recommendation on the parameter setting,
at first, i give the target memory for DB2 is 80% of the physical
memory, it gives me a recommendation on bufferpool size, so i accept
the change, later on , i found that i gave too much memory to DB2, so
i change the target lower, but the recommendation doesn''t change the
buffer pool size accordingly, why is that? thanks

-

Pierre Saint-Jacques - 回复：sesconsjunk at attglobaljunk dot com

重建地址：删除两个垃圾，然后用

替换它们的符号。

IBM DB2 Cerified Solutions Expert - Administration

SES Consultants Inc. br />

--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Xixi，我相信当你说它没有改变时，你仍然是通过COnfigure参数查看值的


COntrol Center中的选项。

此应用程序打开时，会快照DB CFG并选择它读取的

值。当您运行Advisor输出时，您使用immediate或deferred选项更改实际的

文件，并且旧值仍然是缓存并显示的值。

如果使用控制中心的

db下拉列表中的Buffer Pools对象查看bp的大小，您应该会看到新值。如果

没有，只需刷新buffwer池对象。

或者，如果你不介意，只需关闭CC并重新打开它。转到

配置参数，你就可以看到你的新价值了。

HTH，皮埃尔。


xixi写道：

Xixi, I believe that when you say it does not change, you are still
looking at the value through the COnfigure Parameters option in the
COntrol Center.
This application, when it opens, snapshots the DB CFG and picks the
values it reads. When you run the Advisor output, you change the actual
file with the immediate or deferred option, and the old value is still
cached and displayed.
If you look at the size of the bp using the Buffer Pools object in the
db drop down on the control center you should see the new value. If
not, just refresh the the buffwer pool object.
Or, if you do not mind, just close the CC and reopen it. Go to the
Configure parameters and you shouyld see your new value.
HTH, Pierre.

xixi wrote:

我们在windows上使用db2 udb v8.1，我尝试使用
配置顾问来获取有关参数设置的建议，首先，我给出了目标内存对于DB2来说是80％的物理内存，它给我一个关于缓冲池大小的建议，所以我接受改变，后来，我发现我给了DB2太多的内存，所以缓冲池大小，为什么呢？谢谢

we are using db2 udb v8.1 on windows, i try to use the
configuration advisor to get recommendation on the parameter setting,
at first, i give the target memory for DB2 is 80% of the physical
memory, it gives me a recommendation on bufferpool size, so i accept
the change, later on , i found that i gave too much memory to DB2, so
i change the target lower, but the recommendation doesn''t change the
buffer pool size accordingly, why is that? thanks

-

Pierre Saint-Jacques - 回复：sesconsjunk at attglobaljunk dot com

重建地址：删除两个垃圾，然后用

替换它们的符号。

IBM DB2 Cerified Solutions Expert - Administration

SES Consultants Inc. br />

--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

它没有改变，因为配置顾问没有为新缓冲池大小提供

推荐值比如其他

参数，因为我可以看到。即使我关闭控制中心

并重新打开它，它仍然显示使用80％内存的大小，而不是

新的目标内存。谢谢

it doesn''t change because the Configuration advisor didn''t give a
recommendation value for new buffer pool size just like for other
parameters, cause i could see that. even i close the control center
and reopen it, it still display the size which use 80% memory, not the
new target memory. thanks

这篇关于缓冲池大小的配置顾问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！