select
substr(tbsp_name,1,20) as 表空间名称,
substr(tbsp_content_type,1,10) as 表空间类型,
sum(tbsp_total_size_kb)/1024 as 表空间总大小(MB),
sum(tbsp_used_size_kb)/1024 as 已经使用的表空间大小(MB),
sum(tbsp_free_size_kb)/1024 as 剩余表空间大小(MB),
tbsp_page_size AS 页大小
from SYSIBMADM.TBSP_UTILIZATION
group by
tbsp_name,
tbsp_content_type,
tbsp_page_size
order by 3 desc
substr(tbsp_name,1,20) as 表空间名称,
substr(tbsp_content_type,1,10) as 表空间类型,
sum(tbsp_total_size_kb)/1024 as 表空间总大小(MB),
sum(tbsp_used_size_kb)/1024 as 已经使用的表空间大小(MB),
sum(tbsp_free_size_kb)/1024 as 剩余表空间大小(MB),
tbsp_page_size AS 页大小
from SYSIBMADM.TBSP_UTILIZATION
group by
tbsp_name,
tbsp_content_type,
tbsp_page_size
order by 3 desc