The sysviolations system catalog table stores information about constraint violations for base tables.

This table is updated when the DELETE, INSERT, MERGE, or UPDATE statement detects a violation of an enabled constraint or unique index in a database table for which the START VIOLATIONS TABLE statement of SQL has created an associated violations table (and for HCL OneDB™, a diagnostics table). For each base table that has an active violations table, the sysviolations table has a corresponding row, with the following columns.
Column Type Explanation
targettid INTEGER Identifying code of the target table (the base table on which the violations table and the diagnostic table are defined)
viotid INTEGER Identifying code of the violations table
diatid INTEGER Identifying code of the diagnostics table
maxrows INTEGER Maximum number of rows that can be inserted into the diagnostics table by a single insert, update, or delete operation on a target table that has a filtering mode object defined on it.

The maxrows column also signifies the maximum number of rows that can be inserted in the diagnostics table during a single operation that enables a disabled object or that sets a disabled object to filtering mode (provided that a diagnostics table exists for the target table). If no maximum is specified for the diagnostics or violations table, then maxrows contains a NULL value.

The primary key of this table is the targettid column. An additional unique index is also defined on the viotid column.

HCL OneDB also has a unique index on the diatid column.