DSNU805I csect-name - TABLE=table_name COLUMN=column_name IS OUT OF SYNCH ROWID=rowid VERSION=version
Explanation
The CHECK DATA utility found an auxiliary index entry for the LOB column named column_name with ROWID, rowid, and version, version. The base table row with ROWID, rowid, has a version value greater then that of the index record for the column specified.
The state changes below 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.
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. Use REPAIR to delete the LOB from the LOB table space using the ROWID and version reported in the message. Rerun the CHECK DATA utility with AUXERROR INVALIDATE specified. If all Auxiliary Column Check errors were corrected, Aux Warning is reset.
The REPAIR utility can be used to reset the Aux Warning state.
Severity
4 (Warning)