| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| SQL Server and WMB |
« View previous topic :: View next topic » |
| Author |
Message
|
| martinrydman |
 Posted: Sat Nov 18, 2006 2:02 pm Post subject: SQL Server and WMB |
 |
|
Centurion
Joined: 30 Jan 2004
Posts: 139
Location: Gothenburg, Sweden
|
Hi,
Can SQL Server (Microsoft SQL Server 2000 SP4, Standard Edition) be used as an app db for WMB 6.0?
Someone claimed to have seen this statement regarding this:
"Globally coordinated transaction support (‘XA’) is provided only with DB2 and Oracle."
Is this true? If so, does it mean that a mesageflow updating a SQL Server table won't be able to do so within a transaction together with MQ?
TIA
/Martin |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Sat Nov 18, 2006 4:39 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
AFAIK, SQLServer is not XA compliant.
So no XA complaint Transaction Manager, including WMQ, can perform globally coordinated transactions with it.
That said, in WMB v6.0, the Merant drivers allow you to use SQLServer in broker coordinated transactions from all platforms - or at least all distributed platforms.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| martinrydman |
| Posted: Sun Nov 19, 2006 1:19 pm Post subject: |
|
|
Centurion
Joined: 30 Jan 2004
Posts: 139
Location: Gothenburg, Sweden
|
Hi Jeff,
Thanks. As far as I understand, no reason to doubt the feasability of this setup then?
/Martin |
|
| Back to top |
|
|
| UnclDanMan |
| Posted: Tue Nov 21, 2006 12:59 pm Post subject: Yes, it will work |
|
|
Newbie
Joined: 25 Jul 2006
Posts: 6
|
WMB can talk to SQL Server databases, but not from a zOS broker.
On the UNIXes and on Windows, you'll need to create a little stanza in your .odbc.ini file which explains where the database is (server name, etc) - and then you'll need to run setmqdbparams to set the username & password credentials you want broker to use.
_________________
--Daniel Max Kestin |
|
| Back to top |
|
|
| kirani |
| Posted: Tue Nov 21, 2006 4:30 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Martin,
Using XA transactions can have significant performance impact, so you might want to rethink about this solution. I have been using Broker coordinated transactions for over 2 yrs in production and never had any problems with my updates (DB2 and 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 |
|
|
| martinrydman |
| Posted: Tue Nov 21, 2006 11:47 pm Post subject: |
|
|
Centurion
Joined: 30 Jan 2004
Posts: 139
Location: Gothenburg, Sweden
|
Hi,
I'm pretty sure I'm confusing XA transactions with broker coordinated transactions. From your replies, I'm pretty sure broker coordinated transaction will do just fine, considering the fact that I've been doing wmb/db solutions for five years without ever explicitly doing anything with 'XA' in it 
I guess I somehowe assumed that the transaction mechanism of the broker involved XA, but I was obvioulsy wrong there!
Thanks for the feedback!
/Martin |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Nov 22, 2006 2:39 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
In order to use XA transactions in broker, you have to a) configure the queue manager to be the TM, and b) configure your flows to use globally coordinated transactions when you deploy them.
If you've never done either, then you've never used globally coordinated transactions.
And that's usually OK, as long as you code your flows with that in mind. There is still a risk of having out of sync commits (message deleted, db not changed or vice versa), though.
_________________
I am *not* the model of the modern major general. |
|
| 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
|
|
|
|
