onstat -t and onstat -T commands: Print tblspace information

Use the onstat -t command to display tblspace information for active tblspaces. Use the onstat -T command to display tblspace information for all tblspaces.

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


Syntax:

>>-onstat--+- -t-+---------------------------------------------><
           '- -T-'

Example output

Figure 1. onstat -t command output

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

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:

0x00000002: Flush the partition info at the next checkpoint.
0x00000004: Drop partition is in progress.
0x00000008: Partition is a pseudo partition (sysmaster).
0x00000020: ALTER TABLE is in progress.
0x00000040: Partition has been dropped.
0x00000800: Partition is the system temp table.
0x00001000: Partition is the user temp table.
0x00008000: Online index create or drop in progress.
0x00400000: A single user access to the partition is requested.
0x00800000: Drop partition is completed.
0x40000000: Flush the partition info. The partition flush can be delayed until later in the checkpoint process.

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.