收集缓冲池数据 [英] collect bufferpool data

查看:57
本文介绍了收集缓冲池数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我正在尝试获取buffpool的快照,但我得到的只是不是收集b $ b,无论如何我可以收集数据吗?

解决方案

" xixi" <哒**** @ yahoo.com>在消息中写道

news:c0 ************************** @ posting.google.c om ...

我正在尝试获取buffpool的快照,但我得到的只是没有收集,无论如何我可以收集数据吗?




您是否为缓冲池启用了快照监视器?


" xixi" <哒**** @ yahoo.com>在消息中写道

news:c0 ************************** @ posting.google.c om ...

我正在尝试获取buffpool的快照,但我得到的只是没有收集,无论如何我可以收集数据吗?




您是否为缓冲池启用了快照监视器?


在命令行上:

db2 update monitor切换缓冲池on

db2快照.....


我建议你花点时间阅读DB2管理员指南 -

性能。

你最近一直在问的很多问题都是非常广泛的讨论,你可以节省自己的时间并获得一个

更好地了解你的数据库告诉你什么。


HTH''皮埃尔。


xixi写道:
< blockquote class =post_quotes>我正在尝试获取buffpool的快照,但我得到的只是不是
收集了,无论如何我可以收集数据吗?




-

Pierre Saint-Jacques - 回复:attslobaljunk dot的sesconsjunk com $ / $
重建地址:删除两个垃圾并用

代替它们的符号。

IBM DB2 Cerified Solutions Expert - Administration

SES顾问公司


i am trying to get snapshot for buffpool, but all i get is "not
collected", is there anyway i can collect the data?

解决方案

"xixi" <da****@yahoo.com> wrote in message
news:c0**************************@posting.google.c om...

i am trying to get snapshot for buffpool, but all i get is "not
collected", is there anyway i can collect the data?



Did you turn on the snapshot monitor for bufferpools?


"xixi" <da****@yahoo.com> wrote in message
news:c0**************************@posting.google.c om...

i am trying to get snapshot for buffpool, but all i get is "not
collected", is there anyway i can collect the data?



Did you turn on the snapshot monitor for bufferpools?


On command line:
db2 update monitor switches bufferpool on
db2 get snapshot on.....

I would suggest you spend some time reading the DB2 Admin Guide -
Performance.
A lot of the questions you have been asking lately are quite extensively
discussed in there and you would save yourself time as well as gain a
better understanding of what your database is telling you.

HTH'' Pierre.

xixi wrote:

i am trying to get snapshot for buffpool, but all i get is "not
collected", is there anyway i can collect the data?



--
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.


这篇关于收集缓冲池数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆