db2查表空间

最新推荐文章于 2023-12-21 17:36:47 发布

chjf2010

最新推荐文章于 2023-12-21 17:36:47 发布

阅读量412

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/chjf2010/article/details/84517230

版权

数据库专栏收录该内容

15 篇文章 0 订阅

订阅专栏

db2=>connect to test

db2=>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