Checkpoint monitoring

For each monitored database and for each interval, the Checkpoint class records:

- the number of checkpoints during the interval
- the number of checkpoint delays during the interval
- the average duration of a checkpoint
- the average duration of a checkpoint delay

Sample Report

When a checkpoint delay is detected, the Checkpoint Delay table records the name and the state of all users active at that time and, implicitly, the user delaying the checkpoint.

The Command Monitor's Recording facility provides detailed information for each checkpoint performed by DB2.