Saturday, September 13, 2008

DB2 CHECK TABLESPACE STORAGE

SELECT
TBSP_NAME,
(TBSP_TOTAL_SIZE_KB/1024) AS TOTAL,
(TBSP_USABLE_SIZE_KB/1024) AS REAL_SIZE,
(TBSP_FREE_SIZE_KB/1024)AS FREE,
(TBSP_USED_SIZE_KB/1024) AS USED
FROM
SYSIBMADM.TBSP_UTILIZATION
ORDER BY
USED DESC

No comments: