IBM 000-8697 ユーザーズマニュアル

IBM Informix OnLine Database Server Administrator’s Guide

A checkpoint check is performed if the time specified by

CKPTINTVL

 has

elapsed since the last checkpoint. If nothing is in the buffers waiting to be
written to disk at the time of the checkpoint check, no checkpoint is needed.
The time in the

Last Checkpoint Done

 field is not changed until a check-

point occurs.

From the command line, execute tbstat -m to view the last 20 entries of the
OnLine message log. If a checkpoint record does not appear in the last 20
entries, read the message log directly using a

UNIX

 editor. Individual check-

point records are written to the log when the checkpoint ends. No record is
written when a checkpoint check occurs and no checkpoint occurs.

From the command line, execute tbcheck -pr to obtain further information
about the state of OnLine at the time of the last checkpoint. Refer to

for a detailed description of each field in the checkpoint reserved page.

From the command line, execute tbstat -p to obtain the same checkpoint
information as is available from the Status menu, Profile option (

Check-

points

and

Check Waits

 fields). Refer to

 for more information

about the tbstat -p display.

Monitor the OnLine chunks to check for fragmentation (tbcheck -pe) or to
check the availability of free space throughout allocated disk space (all
options).

From

DB-M

onitor, select the Status menu, Spaces option.

The first screen display lists the blobspace or dbspace ID number, the name
of the blobspace or dbspace, the number of assigned chunks, and the
mirroring status of the blobspace or dbspace. If an asterisk appears next to
the

Mirror

 field, one of the chunks in this dbspace or blobspace is down.

Select the dbspace or blobspace that you want to monitor.