
Chapter 6. Point-in-time recovery 121
Figure 6-41 Backup required
We leave the backup options as default, and click OK. DB2 Recovery Expert then
recovers the table, and produces a message when the recovery is complete
(Figure 6-42).
Figure 6-42 ORG table recovered
6.9 PIT recovery of a table space
Recovery of the whole table space to PIT1 is not possible using DB2’s native
recovery methods, as the Minimum Recovery Time was updated when the
ALTER TABLE was run (as explained in 6.1.4, “Recovery without DB2 Recovery
Expert” on page 87).
Using DB2 Recovery Expert, however, recovery of USERSPACE1 to PIT1 is
possible. Figure 6-35 shows the recovery p ...