
Chapter 6. Point-in-time recovery 115
Table 6-2 Scenario C time line
6.5.4 Recovery options without DB2 Recovery Expert
In the absence of DB2 Recovery Expert, the only way to back out of the changes
DEMOAPP made to any of the tables, is to restore the entire database from a
backup, then roll forward through the logs to a point in time just before
DEMOAPP was run. It is impossible to recover only one table, or even just
USERSPACE1 to the PIT before DEMOAPP was run, because the Minimum
Recovery Time for the table space was updated when the DDL was run.
DB2 Recovery Expert allows you to recover any single table or table space to a
PIT, as descr