From dbaccess, database sysmaster, try

select tabname, sum(size) from sysextents
where dbsname = 'my_dbs'
group by 1
order by 1

You may want to filter out table names starting 'sys*', and depending on
version/setup, indexes may be listed separately.

HTH


--
Phil (AT) oninit (DOT) com