DSNU824I XML COLUMN column-name IN TABLE crname, tbname IS NULL BUT ENTRY IN INDEX crname, ixname FOUND. DOCID DocId-hex-string

Explanation

This message is issued when a row in an XML table exists, but it is not referenced by a base table row.

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

Processing continues. This is an informational message. XML processing is not hindered because an XML column entry exists in the auxiliary index, but the XML column in the base table is marked null or has a null length.

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.

Severity

4 (warning)