--application 252上db2 => get monitor switches Monitor Recording SwitchesSwitch list for member 0Buffer Pool Activity Information (BUFFERPOOL) = OFFLock Information ...
显示全部
--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下开启监控,监控视图都会返回数据吗?
收起