
148 DB2 Recovery Expert for Multiplatforms
7.1 Scenario F: Recovery of a dropped table
We illustrate the recovery of a dropped table using DB2 Recovery Expert with the
following scenario.
7.1.1 Scenario description
Table ORG from the database SAMPLE has been dropped and we need to
recover it.
7.1.2 Prerequisites for the scenario
This scenario uses the SAMPLE database, created via the db2sampl command.
It assumes that the database structure and database configuration are the
default, except for the following change:
LOGRETAIN must be set to RECOVERY.
For all of the recovery options detailed in the following sections to work, the
following conditions ...