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
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.
