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:

0x01

Busy

0x02

Dirty (modified pages that have not been flushed to disk)

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.

lockid

is the table ID

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.

The -t option also lists the number of active tblspaces, the number of available tblspaces, and the number of available hash buckets.