DB2 10.5 for Linux, UNIX, and Windows

Recovering from table space errors on an HADR standby

In the event that the HADR standby database encounters an error on a particular table space during log replay, the standby database will continue to replay logs on other table spaces but will stop replaying logs on the affected table space.

About this task

The affected table space's tablespace state will be changed to restore pending, rollforward pending, or offline. You need to recover the table space on the standby because data in this table space will not be available if this database takes over the primary role.

Procedure

  1. Correct the root cause of the error. Possible causes include:
    • Insufficient space
    • The file system is not mounted
    • A load copy could not be found
  2. Repair the affected table space. Do this by completely reinitializing the standby database by restoring a backup image of the primary database.