RE: Actual Used space
Try (in your sysmaster database)
select tabname, sum(size)
from sysextents
where dbsname =3D "<your_database_name>"
group by tabname
order by tabname
This will report the total size (DATA + INDEX) in pages taken up by each =
table. Of course, if your table size is 4 pages and your EXTENT SIZE is =
8 pages, then it will show 8, ie it will show the current extent usage =
for each table.
Hope this helps
Sujit Pal
DBA, Computer Sciences Corp.