OS: IBM AIX
DB: DB2 9.0

Iam trying to find the size of the table using the following query.

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

- Edited: Working fine. Pls cancel this thread