DB2 Recovery Expert for Multiplatforms

Chapter 6. Point-in-time recovery 113

Figure 6-34 Recovery Path page for database recovery

Figure 6-34 shows that, as for table space recovery (Section 6.3, on page 99),

there are two possible recovery paths to recover database SAMPLE back to the

PIT before DEMOAPP was run:

򐂰 UNDO SQL using the DB2 logs

򐂰 Restore from a backup image and roll forward

We will briefly discuss each of these paths in turn.

6.4.1 UNDO SQL using the DB2 logs

The steps required for this path are exactly the same as for table space level

recovery (Section 6.3.1, on page 101). In fact, because all the changes made by

DEMOAPP were in the same table space (USERSPACE1), the UNDO ...