The onstat -d option
Use the onstat
-d option to display the following information about the
chunks in each sbspace:
- Number of free sbpages in each sbspace chunk, in the metadata area, and in the user-data area
- Total number of sbpages in each sbspace chunk, in the metadata area, and in the user-data area
For an example of onstat -d output, see information about the onstat utility in the IBM® Informix® Administrator's Reference.
To find out the total amount of used space, run the oncheck -pe command. For more information, see The oncheck -ce and oncheck -pe options.
The onstat -d option does not register an sbpage as available until the logical login which a deletion occurred is backed up and the sbpage is freed. Therefore, if you delete 25 smart large objects and immediately run onstat -d, the newly freed space is not in the onstat output.