Using the MAX VIOLATIONS Clause (XPS)

Use the MAX VIOLATIONS clause to specify the maximum number of rows that any single coserver can insert into the violations table when a single statement is executed on the target table. Each coserver where the violations table resides has this limit. The first coserver to reach this limit raises an error and causes the statement to fail. If you omit the MAX VIOLATIONS clause, no upper limit exists on the number of rows that can be inserted into the violations table when a single statement is executed on the target table.