Bad-row limit during a load operation

The dbload -e option lets you specify how many bad rows to allow before dbload terminates.

If you set errors to a positive integer, dbload terminates when it reads (errors + 1) bad rows. If you set errors to zero, dbload terminates when it reads the first bad row.

If dbload exceeds the bad-row limit and the -p option is specified, dbload prompts you for instructions before it terminates. The prompt asks whether you want to roll back or to commit all rows that were inserted since the last transaction.

If dbload exceeds the bad-row limit and the -p option is not specified, dbload commits all rows that were inserted since the last transaction.