银行
快照监控方面的一些疑惑
各位好，刚学db2不久，现在对db2的快照监控有些疑惑，向各位请教一下：1： 如果在当前连接打开快照开关，是监控整个数据库的活动吗？不是只监控我当前连接的吧？----语句：update monitor switches using..... 各个监控的统计信息，也是从打开时开始算的吧？2： 实例记... 显示全部
查看其它 5 个回答wangzk0206 的回答
--application 252上
db2 => get monitor switches
Monitor Recording Switches
Switch list for member 0
Buffer Pool Activity Information (BUFFERPOOL) = OFF
Lock Information (LOCK) = OFF
Sorting Information (SORT) = OFF
SQL Statement Information (STATEMENT) = ON 07/22/2013 08:56:51.137388
Table Activity Information (TABLE) = OFF
Take Timestamp Information (TIMESTAMP) = ON 07/22/2013 08:56:51.137388
Unit of Work Information (UOW) = OFF
db2 => select substr(bp_name,1,30) as bp_name,data_hit_ratio_percent,index_hit_ratio_percent,total_hit_ratio_percent from sysibmadm.bp_hitratio
BP_NAME DATA_HIT_RATIO_PERCENT INDEX_HIT_RATIO_PERCENT TOTAL_HIT_RATIO_PERCENT
------------------------------ ---------------------- ----------------------- -----------------------
IBMDEFAULTBP - - -
IBMSYSTEMBP4K - - -
IBMSYSTEMBP8K - - -
IBMSYSTEMBP16K - - -
IBMSYSTEMBP32K - - -
5 record(s) selected.
--在当前application级别开启监控开关
db2 => update monitor switches using bufferpool on
DB20000I The UPDATE MONITOR SWITCHES command completed successfully.
db2 => get monitor switches
Monitor Recording Switches
Switch list for member 0
Buffer Pool Activity Information (BUFFERPOOL) = ON 07/22/2013 14:44:59.080028
Lock Information (LOCK) = OFF
Sorting Information (SORT) = OFF
SQL Statement Information (STATEMENT) = ON 07/22/2013 08:56:51.137388
Table Activity Information (TABLE) = OFF
Take Timestamp Information (TIMESTAMP) = ON 07/22/2013 08:56:51.137388
Unit of Work Information (UOW) = OFF
db2 => select substr(bp_name,1,30) as bp_name,data_hit_ratio_percent,index_hit_ratio_percent,total_hit_ratio_percent from sysibmadm.bp_hitratio
BP_NAME DATA_HIT_RATIO_PERCENT INDEX_HIT_RATIO_PERCENT TOTAL_HIT_RATIO_PERCENT
------------------------------ ---------------------- ----------------------- -----------------------
IBMDEFAULTBP 93.54 93.33 93.47
IBMSYSTEMBP4K - - -
IBMSYSTEMBP8K - - -
IBMSYSTEMBP16K - - -
IBMSYSTEMBP32K - - -
5 record(s) selected.
--发现当前application已经统计到了监控数据！然后在另外一个application再查询同样的监控视图，发现竟然还是
--application 253上
db2 => get monitor switches
Monitor Recording Switches
Switch list for member 0
Buffer Pool Activity Information (BUFFERPOOL) = OFF
Lock Information (LOCK) = OFF
Sorting Information (SORT) = OFF
SQL Statement Information (STATEMENT) = ON 07/22/2013 08:56:51.137388
Table Activity Information (TABLE) = OFF
Take Timestamp Information (TIMESTAMP) = ON 07/22/2013 08:56:51.137388
Unit of Work Information (UOW) = OFF
db2 => select substr(bp_name,1,30) as bp_name,data_hit_ratio_percent,index_hit_ratio_percent,total_hit_ratio_percent from sysibmadm.bp_hitratio
BP_NAME DATA_HIT_RATIO_PERCENT INDEX_HIT_RATIO_PERCENT TOTAL_HIT_RATIO_PERCENT
------------------------------ ---------------------- ----------------------- -----------------------
IBMDEFAULTBP 96.22 97.14 96.59
IBMSYSTEMBP4K - - -
IBMSYSTEMBP8K - - -
IBMSYSTEMBP16K - - -
IBMSYSTEMBP32K
为什么application 253上视图也能看到监控数据哪？也就是说再任何一个application下开启监控，监控视图都会返回数据吗？
db2 => get monitor switches
Monitor Recording Switches
Switch list for member 0
Buffer Pool Activity Information (BUFFERPOOL) = OFF
Lock Information (LOCK) = OFF
Sorting Information (SORT) = OFF
SQL Statement Information (STATEMENT) = ON 07/22/2013 08:56:51.137388
Table Activity Information (TABLE) = OFF
Take Timestamp Information (TIMESTAMP) = ON 07/22/2013 08:56:51.137388
Unit of Work Information (UOW) = OFF
db2 => select substr(bp_name,1,30) as bp_name,data_hit_ratio_percent,index_hit_ratio_percent,total_hit_ratio_percent from sysibmadm.bp_hitratio
BP_NAME DATA_HIT_RATIO_PERCENT INDEX_HIT_RATIO_PERCENT TOTAL_HIT_RATIO_PERCENT
------------------------------ ---------------------- ----------------------- -----------------------
IBMDEFAULTBP - - -
IBMSYSTEMBP4K - - -
IBMSYSTEMBP8K - - -
IBMSYSTEMBP16K - - -
IBMSYSTEMBP32K - - -
5 record(s) selected.
--在当前application级别开启监控开关
db2 => update monitor switches using bufferpool on
DB20000I The UPDATE MONITOR SWITCHES command completed successfully.
db2 => get monitor switches
Monitor Recording Switches
Switch list for member 0
Buffer Pool Activity Information (BUFFERPOOL) = ON 07/22/2013 14:44:59.080028
Lock Information (LOCK) = OFF
Sorting Information (SORT) = OFF
SQL Statement Information (STATEMENT) = ON 07/22/2013 08:56:51.137388
Table Activity Information (TABLE) = OFF
Take Timestamp Information (TIMESTAMP) = ON 07/22/2013 08:56:51.137388
Unit of Work Information (UOW) = OFF
db2 => select substr(bp_name,1,30) as bp_name,data_hit_ratio_percent,index_hit_ratio_percent,total_hit_ratio_percent from sysibmadm.bp_hitratio
BP_NAME DATA_HIT_RATIO_PERCENT INDEX_HIT_RATIO_PERCENT TOTAL_HIT_RATIO_PERCENT
------------------------------ ---------------------- ----------------------- -----------------------
IBMDEFAULTBP 93.54 93.33 93.47
IBMSYSTEMBP4K - - -
IBMSYSTEMBP8K - - -
IBMSYSTEMBP16K - - -
IBMSYSTEMBP32K - - -
5 record(s) selected.
--发现当前application已经统计到了监控数据！然后在另外一个application再查询同样的监控视图，发现竟然还是
--application 253上
db2 => get monitor switches
Monitor Recording Switches
Switch list for member 0
Buffer Pool Activity Information (BUFFERPOOL) = OFF
Lock Information (LOCK) = OFF
Sorting Information (SORT) = OFF
SQL Statement Information (STATEMENT) = ON 07/22/2013 08:56:51.137388
Table Activity Information (TABLE) = OFF
Take Timestamp Information (TIMESTAMP) = ON 07/22/2013 08:56:51.137388
Unit of Work Information (UOW) = OFF
db2 => select substr(bp_name,1,30) as bp_name,data_hit_ratio_percent,index_hit_ratio_percent,total_hit_ratio_percent from sysibmadm.bp_hitratio
BP_NAME DATA_HIT_RATIO_PERCENT INDEX_HIT_RATIO_PERCENT TOTAL_HIT_RATIO_PERCENT
------------------------------ ---------------------- ----------------------- -----------------------
IBMDEFAULTBP 96.22 97.14 96.59
IBMSYSTEMBP4K - - -
IBMSYSTEMBP8K - - -
IBMSYSTEMBP16K - - -
IBMSYSTEMBP32K
为什么application 253上视图也能看到监控数据哪？也就是说再任何一个application下开启监控，监控视图都会返回数据吗？