db2查看表空间

db2查看表空间

文章转自：https://www.cnblogs.com/zuo-zijing/p/3964609.html

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

--表空间授权用户
select * from syscat.TBSPACEAUTH with ur;

--表空间数据文件
select * from sysibmadm.CONTAINER_UTILIZATION with ur;