DSNU813I csect-name - LOB IN TABLE SPACE=lob_table_space_name WITH ROWID=rowid AND VERSION=version HAS NO BASE TABLE ROW

Explanation

The CHECK DATA utility found a LOB in the LOB table space named lob_table_space_name but did not find a row in the base table for this LOB. The LOB has a ROWID of rowid and version of 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

Utility returns completion code=4.

Programmer response

CHECK DATA relies on information in the index on the auxiliary table and LOB table space 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.

The LOB can be deleted using the REPAIR utility. Specify LOCATE ROWID VERSION DELETE.