DSNU814I csect-name - TABLE=table_name COLUMN=column_name IS ZERO OR NULL BUT ENTRY IN INDEX index-name FOUND 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 was indicated null or zero length, but an index entry with the same ROWID was found in the index on the auxiliary table 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
The fact that a LOB column entry exists in the index on the auxiliary table when the LOB column is marked null or has a null length does not hinder LOB column processing.
If AUXERROR INVALIDATE was specified, the LOB column is not set invalid for this error.
Programmer response
CHECK DATA relies on information in the index on the auxiliary table and LOB table space being correct. If you did not run CHECK LOB followed by REBUILD INDEX or CHECK INDEX prior to running CHECK DATA, then before running CHECK DATA again, run CHECK LOB followed by REBUILD INDEX or CHECK INDEX. CHECK LOB checks the validity of the LOB table space and REBUILD INDEX or CHECK INDEX ensures that the auxiliary index is valid.
The LOB can be deleted from the LOB table space by using REPAIR LOCATE TABLESPACE ROWID DELETE
Severity
4 (warning)