DSNI034I csect-name TABLE SPACE table-space-name IS IN AUX WARNING STATE
Explanation
Db2 attempted to recover table space table-space-name, but no log records exist because the table space was created with the LOG NO option. The table space is placed in an auxiliary warning state. You can use SQL statements to update the LOB values that are in error or to delete the row that contains the LOB values. In addition, you can use SQL statements to access valid LOBs. However, you cannot use SQL statements to retrieve a LOB value that is not valid.
System action
Db2 marks the LOB values that are in error as not valid. Processing continues.
Programmer response
Use SQL statements to update or delete the LOB values in error. Use the CHECK LOB utility to verify that all errors were corrected and to reset the auxiliary warning state. The auxiliary warning state can also be reset using the REPAIR utility with SET NOAUXWARN.
Severity
0 (informational)