Concurrency and transactions for the dbload command

You can run multiple dbload commands in parallel to add records to the same or different tables. While loading, you can run concurrent queries, inserts, updates, and deletes against committed records in the target tables.

The dbload command conducts all insertions into the target table within a single transaction. The dbload command commits the transaction at the end of the job if the command does not detect any unrecoverable errors. Only after the dbload command commits the transaction are the newly loaded records visible to other queries. If a load error occurs while multiple concurrent loads are running, only the load with the error is not completed.

If you cancel a dbload job, the dbload command does not commit the transaction.