美文网首页
db2V10.5查看表空间大小

db2V10.5查看表空间大小

作者: 项目实施整理 | 来源:发表于2020-09-16 16:11 被阅读0次

    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"

    相关文章

      网友评论

          本文标题:db2V10.5查看表空间大小

          本文链接:https://www.haomeiwen.com/subject/binaektx.html