Recovery of table space sets

If you restore a page set to a prior state, restore all related tables and indexes to the same point to avoid inconsistencies.

A group of related table spaces is called a table space set. Specifically, a table space set includes the following groups of table spaces:

• Table spaces that contain referentially related tables
• A base table space and its LOB table spaces
• A base table space and its XML table spaces
• A table space with a system-period temporal table and the table space with the related history table
• A table space with an archive-enabled table and the table space with the related archive table

For example, in the Db2 sample application, a column in the EMPLOYEE table identifies the department to which each employee belongs. The departments are described by records in the DEPARTMENT table, which is in a different table space. If only that table space is restored to a prior state, a row in the unrestored EMPLOYEE table might identify a department that does not exist in the restored DEPARTMENT table.

Run the CHECK INDEX utility to validate the consistency of indexes with their associated table data. Run the CHECK DATA utility to validate the consistency of base table space data with related table spaces. If LOB columns exist, run the CHECK LOB utility on any related LOB table spaces to validate the integrity of each LOB table space within itself.

You can use the REPORT utility with the TABLESPACESET option to determine all of the page sets that belong to a single table space set. Then, you can restore those page sets that are related. However, if page sets are logically related outside of Db2 in application programs, you are responsible for identifying all of those page sets on your own.

To determine a valid quiesce point for a table space set, determine a RECOVER TOLOGPOINT value.