DB2 Z/OS

DB2 9 for z/OS

·



Calculating size of Database or Table in DB2 for z/OS :

Calculating all index space in a database:
SELECT DBNAME, SUM(SPACE) FROM SYSIBM.SYSTABLESPACE
WHERE DBNAME = 'DTSG10' GROUP BY DBNAME;

You can query SYSIBM.SYSSTOGROUP to findout total space in KB aquired by a particular storage group.