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:
- Determine the location of the latest checkpoint on the
log by looking at one of the following sources, whichever is more
convenient:
- 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.
- 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.