Primary table recovery

If logical or physical DB2 errors occur, you must run the DB2 RECOVER TABLESPACE utility to rectify a point-in-time recovery.

StepsTo recover to a prior point in time using the RECOVER TABLESPACE utility

  1. Stop replication on the primary DB2 table by selecting option 2 on the Activate and Deactivate Replication panel.

  2. Drop the subscription.

  3. Run the DB2 RECOVER TABLESPACE utility.

  4. Redefine the subscription.

  5. Rematerialize all the subscriptions using data from the recovered DB2 table.

  6. Start replication on the primary DB2 table by selecting option 1 on the Activate and Deactivate Replication panel.

See Chapter 4, “Managing Replication Agent” for more information on primary tables.