Monitoring the system checkpoint

Db2 schedules a system checkpoint every time it switches active log data sets, regardless of the currently defined checkpoint frequency.

About this task

If Db2 switches active logs and finds that there has not been a system checkpoint since the last log switch, it issues the following message to notify the operator that the system checkpoint processor might not be functioning.

DSNJ016E - csect-name WARNING - SYSTEM CHECKPOINT PROCESSOR MAY 
           HAVE STALLED. LAST CHECKPOINT WAS TAKEN date-time

Db2 continues processing. This situation can result in a very long restart if logging continues without a system checkpoint. If Db2 continues logging beyond the defined checkpoint frequency, quiesce activity and terminate Db2 to minimize the restart time.

Procedure

To display the most recent checkpoint, use one of the following approaches:

Issue the DISPLAY LOG command.
Run the print log map utility (DSNJU004).