DB2 Recovery Expert for Multiplatforms

Chapter 5. Log analysis 69

We can then double-click on each of the tables in turn to see what changes were

made to them, and generate Undo SQL if necessary.

5.3.4 Problem resolved

In this case, we look at all the changes made by DEMOAPP and conclude that all

were correct except those relating to the EMPLOYEE table. We then run the

Undo SQL generated (see Figure 5-8) for the changes to the EMPLOYEE table.

We connect to the database and look at the contents of the EMPLOYEE table

after the Undo SQL was run. The problem is resolved. We have recovered from

the incorrect running of DEMOAPP.

To avoid data inconsistency problems it is important that you do not allow

updates on the tables for which you want to run Undo SQL. In our scenario we

first ran ...