db2表空间容量监控

db2表空间容量监控

/*db2表空间容量监控*/
select 
       a.TBSP_NAME || '' as tablespace_name, /*表空间*/
       cast((a.TBSP_TOTAL_SIZE_KB*1.0) / 1024 / 1024 as numeric(18, 2)) AS total_size_g, /*总大小G*/
       cast((a.TBSP_TOTAL_SIZE_KB*a.TBSP_UTILIZATION_PERCENT/100) / 1024 / 1024 as numeric(18, 2)) AS used_size_g, /*已使用G*/
       cast((a.TBSP_TOTAL_SIZE_KB*(100-a.TBSP_UTILIZATION_PERCENT)/100) / 1024 / 1024 as numeric(18, 2)) AS free_size_g, /*剩余G*/
       a.TBSP_UTILIZATION_PERCENT +0 used_persent, /*利用率*/
       sysdate as last_modify_date
FROM SYSIBMADM.MON_TBSP_UTILIZATION a
order by 1,2