
110 DB2 Recovery Expert for Multiplatforms
Figure 6-30 Roll forward not pending
When the recovery is complete, we get the following message (Figure 6-31).
Figure 6-31 Roll forward complete
6.4 PIT recovery of a database
To illustrate recovery of a database to a PIT, we use Scenario B again (from 6.1,
“Scenario B: PIT recovery if SQL has been run” on page 86). Let us suppose that
we want to recover the whole database to the PIT before DEMOAPP was run
(15:14:14).
To begin, we start the DB2 Recovery Expert GUI, connect to SAMPLE, and run
Log Analysis to update the log archive metadata. On the Object Selection page,
we select the Database radio button, ...