onstat -g hwm

Tells you how many pages of each dbspace are in use, and also the used space threshold of the dbspace (also known as the usage high-water mark).

The syntax of the command is:

onstat -g hwm [all | ALL | dbspace_list]

all or ALL

Causes the output to include all dbspaces. This is the default option.

dbspace_list

A list of dbspace names. If this list is given, then only those dbspaces in the list will be included in the output. To separate the names use either commas (,) or colons (:). Do not use any spaces before or after a separator.

Example output

This output is from a system with only one dbspace. It has a total of 15 000 pages, of which 64% are used. The dbspace usage alarm is set to 25%. The used space threshold has been passed and from 51% to 75% of the pages above that threshold have been used.

$  onstat -g hwm

IBM Informix Extended Parallel Server Version 8.50.FN671 -- On-Line -- Up 00:00:57
 -- 75776 Kbytes
num name                            total pages          avail  hwm  %used  over
  1 rootdbs.1                             15000           5255   25     64  ***

Output Description

total pages

The total number of pages in the dbspace.

avail

The number of pages in dbspace that are not yet used.

hwm

The used space threshold (also called the usage high-water mark) for the dbspace. This is given as a percentage of the total pages. For an explanation of the used space threshold and how to set it, see the description of DBS_USED_THRESHOLD on page DBS_USED_THRESHOLD.

%used

The percent of the total pages in the dbspace that are currently used.

over

Shows approximately how many of the pages over and above the used space threshold have been used.

value of over	Roughly this percent of the pages above the used space threshold has been used.
*	1% to 25%
**	26% to 50%
***	51% to 75%
****	over 75%