6 Chapter 6. Backing out insert, update, and delete operations This chapter describes how to use DB2 Recovery Expert to back out the insert, update, and delete operations on table, table space, and database to a point-in-time. This chapter also shows the details of using DB2 Recovery Expert to perform redirected restore and recovering related objects using DB2 Recovery Expert and DB2 Grouper. This chapter includes the following sections: 6.1, "Point-in-time recovery of a table after running DDL" on page 124 6.2, "Recovering table space to point-in-time when DDL has been run" on page 132 6.3, "Point-in-time recovery of table in a DPF environment" on page 138 6.4, "Recovering a database to point-in-time when DDL has been run" on page 145 6.5, "Redirected restore using DB2 Recovery Expert" on page 150 6.6, "Point-in-time recovery with referential integrity and DB2 Grouper" on page 166 © Copyright IBM Corp. 2006. All rights reserved. 123