Backing out incorrect application changes (with a quiesce point)
If you have an established quiesce point, you can back out incorrect changes that your application made.
Procedure
To back out the incorrect changes:
- Run the REPORT utility twice, once using the RECOVERY option
and once using the TABLESPACESET option. On each run, specify the
table space that contains the inaccurate data. If you want to recover to the last quiesce point, specify the option CURRENT when running REPORT RECOVERY.
- Examine the REPORT output to determine the RBA of the quiesce point.
- Run RECOVER TOLOGPOINT with the RBA that you found, specifying the names of all related table spaces.