DB2 Script - Schema Size

DB2 스키마별 용량 체크

SELECT TABSCHEMA
    ,ROUND(SUM(DATA_OBJECT_P_SIZE + INDEX_OBJECT_P_SITE + LONG_OBEJCT_P_SIZE + LOB_OBJECT_P_SIZE)/1024/1024,2) AS TOTAL_SIZE_GB
    ,ROUND(SUM(DATA_OBJECT_P_SIZE + LONG_OBJECT_P_SIZE + LOB_OBJECT_P_SIZE)/1024/1024,2) AS TABLE_SIZE_GB
    ,ROUND(SUM(INDEX_OBJECT_P_SIZE)/1024/1024,2) AS INDEX_SIZE_GB
FROM SYSIBMADM.ADMINTABINFO 
WHERE TABSCHEMA NOT LIKE 'SYS%'
GROUP BY ROLLUP(TABSCHEMA)
ORDER BY 2
WITH UR;