Operating OnLine 3-85

Monitor Tblspaces

Monitor Tblspaces
Monitor tblspaces to determine current space availability and allocation by
table.
Forfurther information about monitoring tblspace extents, refer to page 3-78.
Fromthe command line, execute tbstat -t to obtain general information about
thelimited set of active (or open) tblspaces. The tbstat -t output includes the
tblspace number and the following four fields:
If a specific operation needs more pages than are available (npages minus
nused), a new extent is needed. If there is enough space in this chunk, the
extentis allocated here. If not, OnLine looks in other chunks for the space. If
none of the chunks contain adequate contiguous space, OnLine uses the
largestblock of contiguous space it can find in the dbspace. Refer to page 7-98
for a complete listing of all fields that display when you executetbstat -t.
Executetbcheck -pT to obtain further information about pages, extents,
rows, and index specifics. The -pT options take either a database name or a
table name as a parameter. Refer topage 7-38 for further information about
thetbcheck -pT syntax and page 7-44 for further information about the
output.
npages are the pages allocated to the tblspace.
nused are the pages used from this allocated pool.
nextns is the number of extents used.
npdata is the number of data pages used.