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.
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.