Monitoring Temporary Space Usage

Use the onstat -g tmp option to display the amount of temporary space currently used by the database server. The following optional arguments are available:

onstat -g tmp ALL

Displays usage for all dbspaces.

onstat -g tmp NONCRITICAL

Displays usage for all dbspaces except the root dbspace and other dbspaces the server treats as critical (for example, the dbspace that contains log files).

onstat -g tmp TEMP

Displays usage for temporary dbspaces only.

onstat -g tmp <dbspace list>

A comma-delimited list of dbspaces, dbslices, or dbspace numbers.

If you use onstat -g tmp without an optional argument, the output is based on the value of the DBSPACETEMP environment variable. If the DBSPACETEMP environment variable is not set, the output is based on the DBSPACETEMP configuration parameter.

For more information on the DBSPACETEMP environment variable see the IBM Informix: Guide to SQL Reference. For more information on the DBSPACETEMP configuration parameter see the IBM Informix: Extended Parallel Server Administrator's Reference.

Figure 10 provides an example of the output of onstat -g tmp with no arguments.

informix: onstat -g tmp

IBM Informix Extended Parallel Server Version 8.40.FN361 -- Online -- Up 00:06:15 -- 
72704 Kbytes

Based on the value of the DBSPACETEMP environment variable, these DBspaces
can store temporary files:

num name            type     total pages          used         avail  %used  Max
  1 rootdbs.1          C           40000         24583         15417     61   61
  5 tempdbs3           T           10000            53          9947      0   60
  4 tempdbs2           T            5000            53          4947      1   51
  6 tempdbs4           T            2500            53          2447      2    2
  3 tempdbs1           T             500            53           447     10   10
  2 noncrit1           N             500           447            53     89   89
--------------------------------------------------------------------------------
  6 total spaces                   58500         25242         33258     43   57

The output of onstat -g tmp contains the following information.

Column Name

Description

num

The dbspace number

name

The name of the dbspace

type

"C" for critical
"N" for non critical
"T" for temporary

total pages

The total number of pages in all chunks in the dbspace.

used

The current total number of used pages in all chunks in the dbspace.

avail

The current total number of free pages in all chunks in the dbspace.

%used

The current percentage of pages used in the dbspace as a whole.

Max

The highest percent used since the server was last restarted. Using onstat -z resets this statistic to the current value of the %used column.