DSNU816I csect-name - TABLESPACE table-space-name IS IN AUX WARNING STATE

Explanation

The CHECK DATA utility found auxiliary check errors. AUXERROR INVALIDATE was specified, so LOB columns in error were marked invalid.

Auxiliary warning is a non-prohibitive state. Updating the LOB column or deleting the row containing the LOB column by SQL is permitted. Valid LOBs may be accessed, however any attempt to retrieve an invalid modified LOB column by SQL will result in a -904 return code.

Previous error messages report the errors found.

System action

Processing continues.

Programmer response

Use SQL to update or delete the LOB columns in error. Use CHECK DATA with AUXERROR INVALIDATE to verify all errors were corrected and to reset the auxiliary warning state.

The auxiliary warning state can also be reset using REPAIR with SET NOAUXWARN.

Severity

0 (informational)