Start of change

Correcting XML data after running CHECK INDEX

After you run the CHECK INDEX utility, you might need to correct XML data.

Procedure

To correct XML data:

Based on the CHECK INDEX output, perform one of the following actions:
Problem Action
Problem with a document ID index
  1. Confirm that the base table space is at the correct level.
  2. Rebuild the index.
Problem with an XML table space for a node ID index or an XML index and the index is correct Run REPAIR LOCATE RID DELETE to remove the orphan row.
Problem with an XML table space for a node ID index or an XML index and the index is incorrect Run REBUILD INDEX or RECOVER INDEX to rebuild the index.
Problem with an XML index over an XML table space Run REBUILD INDEX to rebuild the index.
Restriction: Do not run REPAIR LOCATE RID DELETE to remove orphan rows unless the node ID index does not represent the same row and the base table space does not use the document ID index.
End of change