Load commit

[DB2 Novice]

Hello,

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

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

[DB2 Novice]

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

[dotyet]

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

[DB2 Novice]

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

DB2 Novice