IIS-CONN-DB2-00509I Rows that are in violation of a unique index or a primary key index have been deleted.\nIn order to view the deleted rows, please create exception table and set \'Exception table\' stage type property.


Rows that do not have a unique index or that do not have a primary key index have been deleted. Because an exception table was not specified, the rows were not stored.

One or more rows were deleted and stored in the specified exception table. The deleted rows are recorded in the Number of rows deleted entry in the load summary. You can see the load summary in the job log and in the message file specified by the Usage > Load control > Message file property.

User response

Create an exception table and specify the name in the Usage > Load control > Exception table name property. Run the job again to view the deleted rows.