select substr(tbsp_name,1,20) as TABLESPACE_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 from SYSIBMADM.TBSP_UTILIZATION group by
tbsp_name,tbsp_content_type,tbsp_page_size
order by 1
拷下来跑一下吧，全出来了，这个语句可以查出来各个表空间的使用率。别忘了点赞啊
我跑了一下
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024