最近在研究zabbix监控db2,正在研究查询指标的sql语句:
主要有
(1)查询表空间使用率
SELECTsubstr(tbsp_name,1,20) as TABLESPACE_NAME, substr(tbsp_content_type,1,10) asTABLESPACE_TYPE, sum(tbsp_total_size_kb)/1024 as TOTAL_MB, sum(tbsp_used_size_kb)/1024 as USED_MB, sum(tbsp_free_size_kb)/1024 as FREE_MB, tbsp_page_size ASPAGE_SIZE, TBSP_UTILIZATION_PERCENT as percent FROM SYSIBMADM.TBSP_UTILIZATION GROUP BY tbsp_name, tbsp_content_type,tbsp_page_size, TBSP_UTILIZATION_PERCENT ORDER BY TBSP_UTILIZATION_PERCENT
(2)查询表空间当前命中率
select substr(db_name,1,30) asdb_name,substr(bp_name,1,30) as bp_name,data_hit_ratio_percent,index_hit_ratio_percent,total_hit_ratio_percentfrom sysibmadm.bp_hitratio ss join syscat.bufferpools bb on ss.BP_NAME=bb.BPNAME
--------------------查询出来结果为NULL,怎么回事?
请问还有什么查询语句呢?谢谢!