By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,946 Members | 1,600 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,946 IT Pros & Developers. It's quick & easy.

DB2 Load utility and Commit function

P: 1

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

Apr 18 '07 #1
Share this Question
Share on Google+
1 Reply

P: 20
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.
Apr 18 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.