Task 2: Identify incomplete units of recovery and inconsistent page sets

The second task in restarting Db2 by limiting restart processing is to identify incomplete units of recovery and inconsistent page sets.

About this task

Units of recovery that cannot be fully processed are considered incomplete units of recovery. Page sets that will be inconsistent after completion of restart are considered inconsistent page sets.

Procedure

To identify incomplete units of recovery and inconsistent page sets:

  1. Determine the location of the latest checkpoint on the log by looking at one of the following sources, whichever is more convenient:
    • The operator's console contains the following message, identifying the location of the start of the last checkpoint on the log at log RBA X'876B355'. For example:
      DSNR003I RESTART ... PRIOR CHECKPOINT
                           RBA=00007425468
    • The print log map utility output identifies the last checkpoint, including its BEGIN CHECKPOINT RBA
  2. Obtain a report of the outstanding work that is to be completed at the next restart of Db2 by running the DSN1LOGP utility.
    When you run the DSN1LOGP utility, specify the checkpoint RBA as the STARTRBA and the SUMMARY(ONLY) option. In order to obtain complete information, be sure to include the last complete checkpoint from running DSN1LOGP.
  3. Analyze the output of the DSN1LOGP utility.
    The summary report that is placed in the SYSSUMRY file contains two sections of information: a complete summary of completed events and a restart summary.