RE: Chunk really full
Posted in 1997
Topics: Storage & Space Management, Migration, Import/Export & Data Conversion
A few days ago there was a discussion about how to tell if a chunk was
really full or not.
The suggestion was to perform an oncheck -pT for the table in question.
I did this and I have a question about the output of this command.
I have the following output:
Type Pages Empty Semi-Full Full Very-Full
---------------- ---------- ---------- ---------- ---------- ----------
Free 0
Bit-Map 86
Index 0
Data (Home) 345829
----------
Total Pages 345915
Unused Space Summary
Unused data slots 0
Unused bytes per data page 28
Total unused bytes in data pages 9683212
Does this mean that if I unloaded this table, dropped and reloaded that I
would gain 9,683,212 bytes in this dataspace?
Also, just out of curiosity, what do the 'Empty', 'Semi-Full' , etc.
columns mean?
Thanks for any help you can give.
Brenda