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、查询连接数sql：select db_name, appl_name, authid, appl_id, appl_status,client_pid,client_nname, client_platform from sysibmadm.applications
4、查询结果如下：
5、查询蟠校盯昂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、查询db2缓冲池信息select db_name, bp_name,data_hit_ratio_percent,index_hit_ratio_percent,total_hit_ratio_percent from sysibmadm.bp_hitratio
8、查询结果如下：
