Large Data Load with Commit

[1974maiden]

Hello,

I have a table (TblA) with 30m records.

I want to do an Insert into (TblB) that will commit every 100k records at a time....is this possible?

Thanks

 

[gregsimpson]

Jimmy,

if you use the import command you have the option to specify commitcount, in your case commitcount 100000.

Cheers
Greg

 

[1974maiden]

Hi Greg,

I was just looking at the syntax for the Import command and as far as I can see you can only Import from a file.

My current code,

Insert into TblA
Select .. ... from TblB
(a couple of joins etc..)
Commit;

Thanks

 

[gregsimpson]

Jimmy,

Data Movement Utilities Guide and Reference has it all!

Try the following link as regards import and load.

https://aurora.vcu.edu/db2help/db2dm/frame3.htm#db2dm38

Cheers
Greg