| Author |
Message
|
| madiba |
 Posted: Wed Nov 02, 2005 10:26 am Post subject: MQ with SQL Server |
 |
|
Novice
Joined: 14 Oct 2005
Posts: 23
|
I just wanted to find out if MQ works with SQL Server and if so, if there are any performance drawbacks. Also is there a "preferred" database to use with MQ that has advantages over other DBs.
All input will be greatly appreaciated. THANKS. |
|
| Back to top |
|
 |
| urs |
| Posted: Wed Nov 02, 2005 10:31 am Post subject: |
|
|
Acolyte
Joined: 27 Oct 2005
Posts: 56
|
What are you trying to do with the database?  |
|
| Back to top |
|
|
| madiba |
| Posted: Wed Nov 02, 2005 10:38 am Post subject: |
|
|
Novice
Joined: 14 Oct 2005
Posts: 23
|
| MQ will be used as the transaction manager. |
|
| Back to top |
|
|
| urs |
| Posted: Wed Nov 02, 2005 10:45 am Post subject: |
|
|
Acolyte
Joined: 27 Oct 2005
Posts: 56
|
[quote="madiba"]MQ will be used as the transaction manager.[/quote]
Please help us by stating more clearer inorder for us to help you  |
|
| Back to top |
|
|
| madiba |
| Posted: Wed Nov 02, 2005 11:00 am Post subject: |
|
|
Novice
Joined: 14 Oct 2005
Posts: 23
|
| Okay. Here is one scenario. When a message is published would I be able save that message in a SQL Server database? |
|
| Back to top |
|
|
| wschutz |
| Posted: Wed Nov 02, 2005 11:58 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
If you want to do a two phase commit (XA protocol), then you might be able to use MTS (or some other transaction manager) to coordinate the unit of work. MQ cannot be the coordinator in this case
(see: http://www-1.ibm.com/support/docview.wss?rs=171&uid=swg27006285)
If you don't care about an XA commit, then you shouldn't have any problem.
I would recommend using UDB (DB/2) instead, of course... 
_________________
-wayne |
|
| Back to top |
|
|
| urs |
| Posted: Wed Nov 02, 2005 1:17 pm Post subject: |
|
|
Acolyte
Joined: 27 Oct 2005
Posts: 56
|
wschtz: Can you please post the link again !
Thanks,
urs |
|
| Back to top |
|
|
| kevinf2349 |
| Posted: Wed Nov 02, 2005 1:41 pm Post subject: |
|
|
Grand Master
Joined: 28 Feb 2003
Posts: 1311
Location: USA
|
|
| Back to top |
|
|
|
|
