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

Load commit

P: n/a

Hello,

Is there a way to specify 10,000 rows to commit for DB2 Load? Or is it
not applicable here?
DB2 Novice

Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
"DB2 Novice" <db*******@yahoo.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

Hello,

Is there a way to specify 10,000 rows to commit for DB2 Load? Or is it
not applicable here?
DB2 Novice

DB2 LUW or z/OS?

ON DB2 for LUW, if you mean commit every 10,000 rows, you can do that with
an IMPORT using COMMITCOUNT.
Nov 12 '05 #2

P: n/a
I am using DB2 LUW. I am not using Import. I am using load instead. I
don't see a commit option for Load

DB2 Novice

Nov 12 '05 #3

P: n/a
have a look at load command syntax

db2 "? LOAD"

i think "SAVECOUNT n" is what you are looking for.

It specifies that the load utility is to establish consistency points
after every n rows.

regards,
dotyet

Nov 12 '05 #4

P: n/a
So you are saying establishing consistency so that in the event of
failure, the load can restart requires commit to take place?

DB2 Novice

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.