| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| How to connect multiple database from a single queue manager |
« View previous topic :: View next topic » |
| Author |
Message
|
| abraham_isaac |
 Posted: Mon May 12, 2003 3:18 am Post subject: How to connect multiple database from a single queue manager |
 |
|
Newbie
Joined: 12 May 2003
Posts: 2
Location: Mumbai
|
Hi,
We are using two-phse commit in our system. Right now we are able to have connection to a single database from a queue manager. Now we are looking for multiple database connetions from the same queue manager. Please reply in detail about the configuration changes required for the same.
Looking forward for your replies.
Abraham
_________________
Luv & Regards |
|
| Back to top |
|
 |
| bower5932 |
| Posted: Mon May 12, 2003 5:33 am Post subject: |
|
|
Jedi Knight
Joined: 27 Aug 2001
Posts: 3023
Location: Dallas, TX, USA
|
| You need to add some additional XAResourceManager stanzas to your ini file for each of the additional databases. |
|
| Back to top |
|
|
| abraham_isaac |
| Posted: Thu May 22, 2003 9:34 am Post subject: |
|
|
Newbie
Joined: 12 May 2003
Posts: 2
Location: Mumbai
|
Sir
Thanks for ur reply.
I would like to know is it possible to have two connection, to the same database, but different schemas, from the same queue manager. And can we distinguish between these connections using AT clause.
Abraham
_________________
Luv & Regards |
|
| Back to top |
|
|
| wongpcl |
| Posted: Fri Jun 13, 2003 12:47 am Post subject: |
|
|
Novice
Joined: 09 Jan 2002
Posts: 23
|
If the queue manager and the database server (DB2 UDB) are in different machines, how to setup mq server as the resource coordinator to corrdinate the transactions between mq and DB2 Server?
Please help to verify the following setup procedure
1. I think I need to install DB2 Client in the MQ Server and then catalog the remote database which will participate in the 2 phase commit
2. I know I need to update the TP_MON_NAME to mqmax. Should I just need to do it on the DB2 Server DBM CFG or I need to do it on the DB2 Client DBM CFG as well (I mean the MQ client machine)?
3. Update the qm.ini to add the XAResourceManager stanza
Please advise.
Thanks |
|
| 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
|
|
|
|
