ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Message Broker Transaction Model

Post new topic  Reply to topic
 Message Broker Transaction Model « View previous topic :: View next topic » 
Author Message
raghav_138
PostPosted: Wed Oct 14, 2009 3:22 am    Post subject: Message Broker Transaction Model Reply with quote

Newbie

Joined: 04 Aug 2009
Posts: 9

Could you please give inputs on the below queries with respect to Message Broker

1.I have a flow which reads the messages from an input queue,does transformation using WTX node and finally inserts the records into Database.I am running the flow as a coordinated transaction where every thing is committed or every thing is rolled backed.My question is if we are running multiple instances of the flow,will it make any difference performance wise as the transaction is committed one by one and we are always inserting one record at a time?

2.I have a shared variable inside a message flow which stores a counter value that gets incremented every time the flow is invoked.My question is if we are running multiple instances of the flow,wont there be a clash of one instance using an incremented value but other flow is still using the old value?I am using this counter value to be a primary key for a DB table,so I am worried about the shared variable clash duing multiple instances.

3.What are different ways to improve the performance of Database insert from a WMB prospective?Has any one tried to use WMB for a ETL purpose where you insert thousands of records
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Wed Oct 14, 2009 3:55 am    Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

Look at the declaration of shared variables and the meaning of ATOMIC
Have fun
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
raghav_138
PostPosted: Wed Oct 14, 2009 8:50 pm    Post subject: Reply with quote

Newbie

Joined: 04 Aug 2009
Posts: 9

I have already done that,but the shared variables seems to create a problem while I am processing thousands of records and incrementing the counter value.

I am also doing a DB interaction inside my flow.

I suspect the problem to be related with
http://www-01.ibm.com/support/docview.wss?rs=171&uid=swg1IZ40999
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Thu Oct 15, 2009 12:20 am    Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

raghav_138 wrote:
I have already done that,but the shared variables seems to create a problem while I am processing thousands of records and incrementing the counter value.

I am also doing a DB interaction inside my flow.

I suspect the problem to be related with
http://www-01.ibm.com/support/docview.wss?rs=171&uid=swg1IZ40999

So did you enclose any manipulation of the shared variable between ATOMIC tags?
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
smdavies99
PostPosted: Thu Oct 15, 2009 1:17 am    Post subject: Reply with quote

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

I have used the Atomic ... & shared variables to hold message counters.

I wrote a procedure that was called with a single argument. This represented a counter to be updated. As the flow uses 5 additional instances the Atomic... End Atomic was needed to stop clashes and invalid counter updates.

Then every 10 seconds, a Timer fires off and in a compute node, the same procedure is called with the argumend = 0. This then copies (under Atomic...End Atomic) the counter values to other values and then zeros the counters.
Once outside the Atomic block, the ESQL updates a DB with the counters.
This flow is processing something in the order of 1 million messages a day and so far (in 2+ years) the counts are totally accurate.

I does work. A little experimentation and detailed testing is required.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Message Broker Transaction Model
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
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.