DB2 - table sizes

The idea of table sizes in DB2 , can spawn into a wide ranging conversation . This is a quicj script tha I use to output the DB2 table sizes, comparing used and allocated space.

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
with ur;

 Ref:Jack Vamvas(http://www.dba-db2.com)