onstat -t and -T

Use the -t option to display tblspace information for active tblspaces, including whether tblspaces are memory resident. Use the -T option to display the total number of tblspaces.

Example Output

Figure 110. onstat -t Output

IBM Informix Dynamic Server Version 10.00.UC1 -- On-Line -- Up 03:58:08 -- 15360 Kbytes

Tblspaces
 n address  flgs ucnt tblnum   physaddr         npages nused  npdata nrows  nextns
62 a40dc70  0    1    100001   1:14             250    250    0      0      1     
195 ac843e0  0    1    1000df   1:236            16     9      4      53     2     
 2 active, 221 total

Output Description

You can interpret output from this option as follows:

n

Is a counter of open tblspaces

address

Is the address of the tblspace in the shared-memory tblspace table

flgs

Uses the following flag bits to describe the flag:

0x00000001: Partition structure is being initialized
0x00000002: Partition was modified. The modified pages have not been flushed to disk.
0x00000004: Partition is being dropped
0x00000008: Partition is for a pseudo table
0x00000010: Partition is being altered in an ADD INDEX or DROP INDEX operation
0x00000020: Partition is being altered in an ALTER TABLE operation
0x00000080: Partition is being dropped while the dbspace is down
0x00000100: Simple large objects in blobspaces are not deleted when the table is dropped
0x00000200: Partition alter page count is updated
0x00000400: Pages have been altered to the latest database schema
0x00000800: System temp table
0x00001000: User temp table
0x00002000: Partition is resident
0x00004000: Index operations are deferred during recovery
0x00008000: Partition is being truncated
0x00010000: Partition is partially truncated

ucnt

Is the usage count, which indicates the number of user threads currently accessing the tblspace

tblnum

Is the tblspace number expressed as a hexadecimal value

The integer equivalent appears as the partnum value in the systables system catalog table.

physaddr

Is the physical address (on disk) of the tblspace

npages

Is the number of pages allocated to the tblspace

nused

Is the number of used pages in the tblspace

npdata

Is the number of data pages used

nrows

Is the number of data rows used

nextns

Is the number of noncontiguous extents allocated

This number is not the same as the number of times that a next extent has been allocated.

resident

Indicates whether tblspace is memory-resident; 1 = yes, 0 = no

The -t option also lists the number of active tblspaces and the total number of tblspaces.