Logging integrity constraint violations

LOAD TABLE allows you to control load behavior when integrity constraints are violated and to selectively log information about the violations. Using the MESSAGE LOG ... ROW LOG option with the ONLY LOG clause, you can direct the load to log information about specific types of integrity constraint violations both per violation in a message log file and per row in a row log file. If the ONLY LOG clause is not specified, only the timestamps indicating the start and completion of the load are logged in these files.

Note that the message log and row files for integrity constraint violations are distinct from the IQ message log file (.iqmsg).