系统巡检指令之db2数据库表空间使用情况检查

首先连接数据库

db2 connect to 数据库名

可以列出数据库详细表空间情况

db2 list tablespaces show detail

也可以使用如下指令展示表空间大小与占比等情况

db2 "select char(TBSP_NAME,50) as TBSP_NAME, TBSP_USABLE_PAGES, TBSP_USED_PAGES, rtrim(100*TBSP_USED_PAGES/TBSP_USABLE_PAGES)||'%' as USED_RATE from sysibmadm.SNAPTBSP_PART where TBSP_USABLE_PAGES>0 order by TBSP_NAME,DBPARTITIONNUM"

db2 
"SELECT
    SUBSTR(TABLESPACE_NAME,1,20)              AS TBSPC_NAME,
    bigint(TOTAL_PAGES * PAGE_SIZE)/1024/1024 AS TOTAL,
    used_pages*PAGE_SIZE/1024/1024            AS USED,
    free_pages*PAGE_SIZE/1024/1024            AS FREE
FROM
    TABLE(snapshot_tbs_cfg('FJDC2', -2)) AS snapshot_tbs_cfg"