DB2 Recovery Expert for Multiplatforms

Chapter 6. Point-in-time recovery 99

Figure 6-15 Table recovered

6.3 PIT recovery of a table space

To illustrate recovery of a table space 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 all tables in the USERSPACE1 table space to the PIT

before DEMOAPP was run (15:14:14).

To begin, we choose tablespace in the Object Selection page, then click the “...”

button and retrieve a list of table spaces (Figure 6-16).

Figure 6-16 Select a table space

We select USERSPACE1, click OK then click Next on the Object Selection page to

get to the Point-in-time Selection ...