DSXchange

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

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

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

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

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

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

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

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

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