DSNU822I XML COLUMN column-name IN TABLE tbcreator, tbname IS MISSING IN INDEX ixcreator, ixname DOCID DocId-hex-string
Explanation
This message is issued when a base table row contains an XML column value, but no index entry is found for the XML column value in the NODEID index.
The state changes take place if SHRLEVEL REFERENCE is specified or defaulted. If SHRLEVEL CHANGE is specified, the state of the table space remains unchanged.
System action
If you specified AUXERROR REPORT, then only this error is reported. The base table space is set to an auxiliary check pending state. If you specified AUXERROR INVALIDATE, then the XML column is set to invalid. The base table space is set to an auxiliary warning state.
Programmer response
Before running CHECK DATA to check the auxiliary columns, run REBUILD INDEX or CHECK INDEX. REBUILD INDEX or CHECK INDEX ensures the validity of the auxiliary index.
If you specified AUXERROR REPORT, run the CHECK DATA utility with AUXERROR INVALIDATE in order to set the base table column to invalid.
If you specified AUXERROR INVALIDATE, use SQL to update the XML column, or delete the base table row. Run the CHECK DATA utility again, with AUXERROR INVALIDATE specified.
If all auxiliary column check errors were corrected, auxiliary warning will be reset.
Severity
4 (warning)