| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| WBIMB Coordinated message flows |
« View previous topic :: View next topic » |
| Author |
Message
|
| Testo |
 Posted: Mon Jun 28, 2004 6:16 am Post subject: WBIMB Coordinated message flows |
 |
|
Centurion
Joined: 26 Feb 2003
Posts: 120
Location: Italy - Milan
|
Following the WMQ Infocenter, I was able to define an XA resource for the broker QMgr to enable 'Coordinated Message Flows' as per the WBIMB help.
Now I have some questions:
1. In theory, all the flows that run on that broker, can be coordinated by WMQ (if obviously all the Transaction properties in the WBIMB nodes are defined correctly and the BAR file has the 'Coordinated transaction' flag checked)?
2. Specifing the XA resource in the QMgr properties, I didn't mention any specific datasource: I have only specified the DB2 Switch file: does this mean that ANY DB, if referenced in the flows, is coordinated by WMQ?
3. How can I experiment (this is a lack of experience with XA, sorry about that) that XA is working properly? Are there any 'best practices'? In practice, I would like to simulate a failure between the prepare commit for the DB and the following prepare commit for MQ.
Thanks in advance for any hint,
Cheers,
Andrea Tedone
AMS IT Specialist |
|
| Back to top |
|
 |
| kirani |
| Posted: Mon Jun 28, 2004 11:16 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
| Testo wrote: |
1. In theory, all the flows that run on that broker, can be coordinated by WMQ (if obviously all the Transaction properties in the WBIMB nodes are defined correctly and the BAR file has the 'Coordinated transaction' flag checked)?
|
To coordinate transactions (UOW) MQ makes use of Syncpoint option. In this case you don't need to check Coordinated Transacion flag in the BAR file. This flag is for 2-phase commit (Globally Coordinated Transaction) only.
| Testo wrote: |
2. Specifing the XA resource in the QMgr properties, I didn't mention any specific datasource: I have only specified the DB2 Switch file: does this mean that ANY DB, if referenced in the flows, is coordinated by WMQ?
|
You need to create one resource for each DB that will participate in the global UOW. I believe you will get deploy/runtime errors if the message flow is accessing DB XYZ and a resource is not defined for it.
| Testo wrote: |
3. How can I experiment (this is a lack of experience with XA, sorry about that) that XA is working properly? Are there any 'best practices'? In practice, I would like to simulate a failure between the prepare commit for the DB and the following prepare commit for MQ.
|
I don't know about the best practice, but you can simulate MQ errors by disabling the output queue. For DB errors, you can revoke the permissions on the DB Object for a user.
I hope this helps.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| Testo |
| Posted: Tue Jun 29, 2004 2:15 am Post subject: |
|
|
Centurion
Joined: 26 Feb 2003
Posts: 120
Location: Italy - Milan
|
Thank you Kiran for your feedback.
I'm wondering about this:
| kirani wrote: |
You need to create one resource for each DB that will participate in the global UOW. I believe you will get deploy/runtime errors if the message flow is accessing DB XYZ and a resource is not defined for it.
|
When I defined the XA Resource in the WMQ Services panel for my broker Qmgr, I specified a name for my Resource, the path for the SwitchFile, the value 'MQ' for the XAOpenString and I left the default 'PROCESS' for the item ThreadOfControl. So actually I didn't specify ANY datasource... The only thing that I can think about is that the name of the XA Resource should be the same as the datasource?!
Thanks,
Andrea |
|
| Back to top |
|
|
| kirani |
| Posted: Tue Jun 29, 2004 1:13 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Andrea,
Well Resource Name is just a string. It must be unique within the queue manager (qm.ini file). It need not match your DB name. XAOpenString is what identifies the DB name. An example of value for XAOpenString could be DB=MyDBName,UID=myuser,PWD=mypwd,TPM=MQ.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| Testo |
| Posted: Tue Jun 29, 2004 2:13 pm Post subject: Thanks |
|
|
Centurion
Joined: 26 Feb 2003
Posts: 120
Location: Italy - Milan
|
Thanks Kiran,
helpful as usual.
Cheers,
Andrea |
|
| 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
|
|
|
|
