MQSeries.net :: View topic - Commit the transaction at row level or at each update.

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Commit the transaction at row level or at each update.

Commit the transaction at row level or at each update.

« View previous topic :: View next topic »

Author

Message

Harshalw

Posted: Fri Aug 01, 2008 6:36 am Post subject: Commit the transaction at row level or at each update.

Voyager

Joined: 23 Jul 2008
Posts: 77

Hi,

I am accessing the database DB2 from WMB 6.1 through compute node.
Compute node has a poperty - Transaction
where option Automatic is at Message flow level
and option Commit is at Node level.

In my Program, i will be updating DB2 table almost 100 times. And i need to commit after every transaction is successful. Please let me know what should be done for this.

Thanks
Harshalw.

broker_new

Posted: Fri Aug 01, 2008 11:47 am Post subject:

Yatiri

Joined: 30 Nov 2006
Posts: 614
Location: Washington DC

I didn't understand your question correctly but
First case if you are updating the database 100 times in a single transaction(in the compute node by using a loop) then you need to passthru('COMMIT') after each update statement.

If each update is a separate transaction then u can set transaction level to commit on the compute node which commits for each transaction.

Harshalw

Posted: Sun Aug 03, 2008 11:43 pm Post subject:

Voyager

Joined: 23 Jul 2008
Posts: 77

Does setting the commit as a transaction level property in compute node will commit as per transaction level or at after complete node processing ?

Also can i use passthru('COMMIT') for committin for per transaction

elvis_gn

Posted: Mon Aug 04, 2008 12:36 am Post subject:

Padawan

Joined: 08 Oct 2004
Posts: 1905
Location: Dubai

Hi Harshalw,

Harshalw wrote:

Does setting the commit as a transaction level property in compute node will commit as per transaction level or at after complete node processing ?

At node level.

Harshalw wrote:

Also can i use passthru('COMMIT') for committin for per transaction

broker_new told you so above..

Regards.

jeeth_m

Posted: Mon Aug 04, 2008 2:09 am Post subject:

Voyager

Joined: 21 Jan 2002
Posts: 93

Broker_new,
I too have a similar question...

Lets say

counter = 0
while counter < 100
update database
passthru(commit)
end while

is this what is being suggested?

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Commit the transaction at row level or at each update.

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP