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.