Recovering a table space that contains LOB or XML data

Db2 marks a LOB or XML column invalid if all of the following conditions are true:

• The LOB table space or XML table space was defined with the LOG(NO) attribute.
• The LOB table space or XML table space was recovered.
• The LOB or XML was updated since the last image copy.

The status of an object that is related to a LOB or XML table space can change due to a recovery operation, depending on the type of recovery that is performed. If all of the following objects for all LOB or XML columns are recovered in a single RECOVER utility statement to the present point in time, no pending status exists:

• Base table space
• Index on the auxiliary table
• LOB table space
• XML table space

The RECOVER utility verifies that all related objects that are required to perform a point-in-time recovery are included in the RECOVER control statement. The VERIFYSET keyword enables you to control whether a point-in-time recovery requires all base, LOB, XML, and history objects in a set. You can choose to break up point-in-time recoveries into multiple jobs with VERIFYSET NO.