Correcting XML data after running CHECK DATA
After you run the CHECK DATA utility, you might need to correct XML data.
Procedure
To correct XML data after running CHECK DATA:
Based on the CHECK DATA output, perform one of the following
actions:
| Problem | Action |
|---|---|
| Problem with corrupted XML data | REPAIR statements are generated to delete each corrupted XML document from the XML table space and its associated node ID index entry. |
| Problem with document ID index | Run generated REPAIR LOCATE TABLESPACE control statements. |
| Problem with node ID index | Run generated REPAIR LOCATE TABLESPACE control statements. |
| Problem with integrity of XML column in the base table and the node ID index |
