Using onstat Options

You can use the following onstat options to obtain checkpoint information:

• -m
• -p

Execute onstat -m to view the last 20 entries in the message log. If a checkpoint record does not appear in the last 20 entries, read the message log directly with a text editor. The database server writes individual checkpoint records to the log when the checkpoint ends. If a checkpoint check occurs, but the database server has no pages to write to disk, the database server does not write any records to the message log.

Execute onstat -p to obtain these checkpoint statistics:

• Number of checkpoints that occurred since the database server was brought online (numckpts)
• Number of times that a user thread waits for a checkpoint to finish (ckpwaits)

  The database server prevents a user thread from entering a critical section during a checkpoint.