
Chapter 6. Point-in-time recovery 87
6.1.4 Recovery without DB2 Recovery Expert
This is the same as for Scenario A (5.2.4, “Recovery options without DB2
Recovery Expert” on page 61).
6.2 PIT recovery of a table
Let us suppose that the sequence of events described in Scenario B has
occurred. We know from experience that the changes DEMOAPP made to the
EMPLOYEE table are incorrect. We do not need to know what SQL was run by
DEMOAPP, we just want to reverse any changes it made.
Use of the Log Analysis Tool is not required in this situation. In fact, if we
produced Undo SQL using log analysis for only the changes DEMOAPP made to
EMPLOYEE, that Undo ...