银行
快照监控方面的一些疑惑
各位好，刚学db2不久，现在对db2的快照监控有些疑惑，向各位请教一下：1： 如果在当前连接打开快照开关，是监控整个数据库的活动吗？不是只监控我当前连接的吧？----语句：update monitor switches using.....
各个监控的统计信息，也是从打开时开始算的吧？
2： 实例记得监控开关打开有什么好处，有什么坏处哪？大家在生产环境打开了吗？
3： 快照相关的管理视图中的统计信息是不是不受监控开关的影响啊？是从数据库启动开始就统计的吗？
各个监控的统计信息，也是从打开时开始算的吧？
2： 实例记得监控开关打开有什么好处，有什么坏处哪？大家在生产环境打开了吗？
3： 快照相关的管理视图中的统计信息是不是不受监控开关的影响啊？是从数据库启动开始就统计的吗？
6同行回答
--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下开启监控，监控视图都会返回数据吗？收起
浏览950
浏览909