I am using DMS raw. I have a tablespace which is defined with 5
containers each allocated at 1.5 GB for a total of about 7.5 GB. I did
a major deletion followed by a reorg and a runstats. I am not
regaining as much space as anticipated. Additionally, the
syscat.tables and syscat.indexes show my usage to be small. How do I
determine who is using all the space ?
The list tablespaces shows -
Usable pages = 7.4 GB
Used pages = 6.2 GB
Free pages to be 1.2 GB
I select from syscat.tables and see sum(fpages) = 466 MB.
I select from syscat.indexes and see sum(nleaf) = 33 MB.
The extentsize is 32 and the page size is 4096. Both data, index and
LOB use the same tablespace. SYSCAT.COLUMNS reveals that some of these
tables do have CLOB columns.
Can anyone tell me how to determine how much is really free ? Is the
used pages really this high? I am thinking not. Thanks.