Filter
Top Products
Operating OnLine 3-85
Monitor Tblspaces
Monitor Tblspaces
Monitor tblspaces to determine current space availability and allocation by
table.
For further information about monitoring tblspace extents, refer to page 3-78.
From the command line, execute tbstat -t to obtain general information about
the limited 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
extent is allocated here. If not, OnLine looks in other chunks for the space. If
none of the chunks contain adequate contiguous space, OnLine uses the
largest block 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 execute tbstat -t.
Execute tbcheck -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 to page 7-38 for further information about
the tbcheck -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.