DB2 Load utility and Commit function

[dbuser]

Hi

I am new to Db2. I am planning to load around 5 million Data using DB2 LOAD utility. Do this utility have an inbuilt COMMIT statement so that i do not get any table locks/deadlock error.

Also if it does commit when does the records gets COMMITED meaning at the end of the full load or after each loaded record

Is there any COMMIT syntax that i can add to the load utility

Thanks

[kalexin]

load will commit at the end of the full load. commit at each record is too expensive. Depending on your system, load can generate a discard file of rejected records.