|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
 |
|
Message Broker Transaction Model |
« View previous topic :: View next topic » |
Author |
Message
|
raghav_138 |
Posted: Wed Oct 14, 2009 3:22 am Post subject: Message Broker Transaction Model |
|
|
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 |
|
 |
fjb_saper |
Posted: Wed Oct 14, 2009 3:55 am Post subject: |
|
|
 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 |
|
 |
raghav_138 |
Posted: Wed Oct 14, 2009 8:50 pm Post subject: |
|
|
Newbie
Joined: 04 Aug 2009 Posts: 9
|
|
Back to top |
|
 |
fjb_saper |
Posted: Thu Oct 15, 2009 12:20 am Post subject: |
|
|
 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 |
|
 |
smdavies99 |
Posted: Thu Oct 15, 2009 1:17 am Post subject: |
|
|
 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 |
|
 |
|
|
 |
|
Page 1 of 1 |
|
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
|
|
|
|