Filter
Top Products
3-76 IBM Informix OnLine Database Server Administrator’s Guide
Monitor Dbspaces
The chunk status flags are defined as follows:
From the Command Line
From the command line, execute tbstat -d to obtain the information that is
similar to the information available from the Dbspaces menu, Info option.
However, where DB-Monitor lists the number of used disk pages, tbstat -d
lists the number of free disk pages and, in the bpages field, the approximate
number of free blobpages. For further information about the bpages field,
refer to page 3-63.
For further information about the tbstat -d display, refer to page 7-84.
From the command line, execute tbcheck -pr to obtain the dbspace infor-
mation that is stored in the root dbspace reserved page. The reserved page
contains the following dbspace information:
■ dbspace name, owner, and number
■ Flags indicating if the dbspace mirror status and if the dbspace is a
blobspace
■ Number of chunks in the dbspace
For further information about the fields in the dbspaces reserved page, refer
to page 2-99.
Flag Description
- Chunk belongs to a dbspace.
B Chunk belongs to a blobspace.
D Chunk is down.
M Chunk is a mirror chunk.
P Chunk is a primary chunk.
R Chunk is in recovery mode.
X Mirroring has been requested but the chunk contains a logical log
file; a level-0 archive is needed before this mirror can begin
functioning.