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.

Read syntax diagramSkip visual syntax diagram
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.


Copyright© 2019 HCL Technologies Limited