I have a table Say X and let the table conatins around 9 million records. How do I calucalte exactly how much GB/MB the table uses in DASD. I am always having trobule in this

Multiply the number of table pages from SYSCAT.TABLES by the tablespace page size in SYSCAT.TABLESPACES.

Thanks

So if have NPAGES =1000 and Page SIZe = 4 then total size should be 4000KB . Am I thinking correct ?

You also might want to look into SYSIBMADM.ADMINTABINFO

try this query

db2 "select char(date(t.stats_time))||' '||char(time(t.stats_time)) as statstime ,substr(t.tabschema,1,4)||'.'||substr(t.tabname,1, 24) as tabname , card as rows_per_table , decimal(float(t.npages)/ ( 1024 / (b.pagesize/1024)),9,2) as used_mb , decimal(float(t.fpages)/ ( 1024 / (b.pagesize/1024)),9,2) as allocated_mb from syscat.tables t , syscat.tablespaces b where t.tbspace=b.tbspace" | grep -i tablename

This will give you the list of tables and their size and size allocated to them in MB..


--Harsh