Commit Size in DB2 Bulk Load Stage ?

kaps · Post by **kaps** » Thu Apr 03, 2008 1:20 pm

Hi

I am not able to find commit size or commit interval in DB2 Bulk load stage.

Does this mean it gets commited after loading all the records into table ? If that's the case then what is the use of Restart count parameter in this stage ?

Please advise.

Thanks

DSguru2B · Post by **DSguru2B** » Thu Apr 03, 2008 1:51 pm

Use help property to find out what that particular property is for. I know there is a place where you can specify commit intervals, maybe Transaction count

ray.wurlod · Post by **ray.wurlod** » Thu Apr 03, 2008 5:00 pm

There's no such thing as COMMIT when bulk loading. Bulk loading is not a transactional operation.

MT · Post by MT » Fri Apr 04, 2008 12:42 am

Hi,

the Db2 Load utility writes directly to the storage (containers) and does not use the SQL insert. Therefore the data can not be commited until the load utility finishes.
BUT there is an option SAVECOUNT which implements consistency points - similar to commit but not on a SQL basis.
So SAVECOUNT (in DataStage it is Save Count) is what you are looking for.

kind regards
Michael

ray.wurlod · Post by **ray.wurlod** » Fri Apr 04, 2008 12:44 am

Good catch - I was thinking transactional, and neglected consistency save points.

DSguru2B · Post by **DSguru2B** » Fri Apr 04, 2008 8:55 am

THere you go. SaveCount was the property. Duh... Its been a while since I used a db2 bulk loader

kaps · Post by **kaps** » Sun Apr 06, 2008 9:07 pm

If Save Count is the parameter then what should I use there as it's based on consistency points. As for as I know consistency ponits are different phases of bulk loader so I don't think I can give any number there.

Also then what is the use of Restart Count parameter in there ?

Thanks for the replies

attu · Post by **attu** » Thu Sep 18, 2008 1:06 pm

MT wrote:Hi,

the Db2 Load utility writes directly to the storage (containers) and does not use the SQL insert. Therefore the data can not be commited until the load utility finishes.
BUT there is an option SAVECOUNT which implements consistency points - similar to commit but not on a SQL basis.
So SAVECOUNT (in DataStage it is Save Count) is what you are looking for.

kind regards
Michael

how can we achieve this using db2 ee stage, where we can commit certain number of records being loaded in db2 table.
Thanks

chulett · Post by **chulett** » Thu Sep 18, 2008 1:16 pm

By starting your own thread over in the PX forum, of course!