Limiting Insertion Errors - Parallel Transporter

Limiting Insertion Errors

Use the TD_ERROR_LIMIT attribute to limit the number of insertion errors captured in ErrorTable1 during the acquisition phase of a Load job.

Table 14: TD_ERRORLIMIT Values 

Load Driver Job Quality	ERRORLIMIT Value
No errors or very few errors	low
Many errors that are considered allowable	high

The ErrorLimit specification applies to each instance of the Load driver, not to all instances combined. For example, you set the limit to 10,000 rows. A single instance must detect that 10,000 rows were inserted into the first error table to terminate the job, and those 10,000 rows must be controlled by the sessions managed by that instance.