IBM 000-8697 User Manual

Operating OnLine

Monitor tblspaces to determine current space availability and allocation by
table.

For further information about monitoring tblspace extents, refer to

.

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

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

 for further information about

the tbcheck -pT syntax and

 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.