DB2数据库监控sql

1、1.溽朽孑臾查询表空间利用率情况对应sql：select substr(tbsp_name,1,20) as tab造婷用痃lespace_name, substr(tbsp_content_type,1,10) as tablespace_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 as page_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、展示结果如下：

3、2.查询连接数sql：select db_name, appl_name, authid, appl_id, appl_status,client_pid,client_nname, client_platform from sysibmadm.applications

4、查询结果如下：

5、3.查询蟠校盯昂db2锁信息：相关sql：select DB_NAME,AGENT_ID,APPL_NAME,AU皈其拄攥THID,TBSP_NAME,TABSCHEMA,TABNAME,LOCK_OBJECT_TYPE,LOCK_NAME,LOCK_MODE,LOCK_STATUS from sysibmadm.LOCKS_HELD

6、查询结果如下：

7、4.查询db2缓冲池信息select db_name, bp_name,data_hit_ratio_percent,index_hit_ratio_percent,total_hit_ratio_percent from sysibmadm.bp_hitratio

8、查询结果如下：