select
tbsp_id,
varchar(tbsp_name,30),
tbsp_used_size_kb/1024 as "usedsize(MB)",
tbsp_max_size/1024/1024 as "maxsize(MB)",
dec(cast(tbsp_used_size_kb as float)*1024/tbsp_max_size*100,15,3)
from
sysibmadm.tbsp_utilization
where
tbsp_max_size>0
order by tbsp_name
|
查看DB2表空间使用率
标签：lin class oat border cell order rom char maxsize