DSNU809I csect-name - TABLE=table_name COLUMN=column_name IS MISSING IN INDEX index-name ROWID=rowid VERSION=version
Explanation
The CHECK DATA utility found a record in the table named table-name in the row with a ROWID of rowid. The column named column-name did not have an index entry in the on the auxiliary index named index-name. The version for the LOB column was version.
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 AUXERROR REPORT was specified, this error is reported only. The base table space is set to an Aux Check Pending state.
If AUXERROR INVALIDATE was specified, the LOB column is set invalid. The base table space is set to an Aux Warning state.
Utility returns completion code=4.
Programmer response
CHECK DATA relies on information in LOB table space and in the auxiliary index being correct. Before running CHECK DATA to check auxiliary columns, first run CHECK LOB and then run REBUILD INDEX or CHECK INDEX. CHECK LOB ensures the validity of the LOB table space. REBUILD INDEX or CHECK INDEX ensures the validity of the auxiliary index.
If AUXERROR REPORT was specified, run the CHECK DATA utility with AUXERROR INVALIDATE to set the base table column invalid.
If AUXERROR INVALIDATE was specified, use SQL to update the LOB column or delete the base table row. Rerun the CHECK DATA utility with AUXERROR INVALIDATE specified. If all Auxiliary Column Check errors were corrected, Aux Warning will be reset.
The REPAIR utility can be used to reset the Aux Warning state.