Effects of running RECOVER

RECOVER without the REUSE option

When you run the RECOVER utility without the REUSE option and the data set that contains that data is DB2®-managed, DB2 deletes this data set before recovery. Then, DB2 redefines a new data set with a control interval that matches the page size.

Recovering objects to a previous point in time

If you use the RECOVER utility to recover objects to a previous point in time, the counter columns in the real-time statistics tables might not be valid. Therefore, after any point-in-time recoveries, you must run the following utilities:

• REORG TABLESPACE to reestablish real-time statistic values for table spaces
• REBUILD INDEX to reestablish real-time statistic values for indexes

These actions do not apply if you recover objects to the current state. When you recover objects to the current state, the counter columns in the real-time statistics tables are still valid. DB2 does not modify them.