318 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
8.6.3 Recovery
If you are performing a table space recovery and the table space already exists,
you can select “End of logs” to recover the selected database objects by
restoring data and processing the recovery logs through the end of the available
log data. Use this option to fix a problem where the log data was correct but the
database contents became physically corrupted.
To use DB2 Recovery Expert, the monitored database must be recoverable; the
logarchmeth1 database configuration parameter must be set to disk or storage
manager.
The following scenario illustrates how DB2 Recovery Expert can be used to
recover a dropped table. The schema level repository retains a copy of system
catalog tables each time you refresh the schema level repository following
backup operations. Using the Recovery option from the Task Manager menu,
you can browse through and select the objects that you want to recover.
In our example, as shown in Figure 8-6 on page 319, we want to recover the
schema CSTINSIGHT and the dropped table CUSTOMER_TXN. DB2 Recovery
Expert correctly identifies the dependencies, table space TA, involved in the
recovery process.