MQSeries.net :: View topic - QM Connecting to Multiple DB2 Instances

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » IBM MQ Installation/Configuration Support » QM Connecting to Multiple DB2 Instances

QM Connecting to Multiple DB2 Instances

« View previous topic :: View next topic »

Author

Message

TonyD

Posted: Wed Jan 29, 2003 8:33 pm Post subject: QM Connecting to Multiple DB2 Instances

Knight

Joined: 15 May 2001
Posts: 540
Location: New Zealand

We are having some difficulty configuring our environment to allow a development queue manager to connect to multiple DB2 instances for transaction co-ordination. Could anyone provide some guidance re the DB2 and MQ configuration steps we should follow to achieve this?

leongor

Posted: Thu Jan 30, 2003 12:17 am Post subject:

Master

Joined: 13 May 2002
Posts: 264
Location: Israel

Here an example configuring MQ Java with DB2 :
http://www.kolban.com/mq/XA/MQ%20and%20global%20transactions.htm
_________________
Regards.
Leonid.

IBM Certified MQSeries Specialist.

TonyD

Posted: Thu Jan 30, 2003 1:11 pm Post subject:

Knight

Joined: 15 May 2001
Posts: 540
Location: New Zealand

Thanks for response....however we have no difficulty configuring for a single DB2 instance, as shown in Neil's doc...our problem seems to be in co-ordinating the instance that the queue manager connects to with the instances that the individual apps are using.

bower5932

Posted: Fri Jan 31, 2003 5:54 am Post subject:

Jedi Knight

Joined: 27 Aug 2001
Posts: 3023
Location: Dallas, TX, USA

I thought that you just needed to add another XAResourceManager stanza to your qm.ini file. Your program then worked as normal. There are a couple of single db samples (mqadhoc.c - cli; mqdb2.sqc - embedded sql) at http://www.developer.ibm.com/tech/sampmq.html. Does this help?

(Note: If your on Windows, you use the explorer to add the stanzas.)

TonyD

Posted: Sat Feb 01, 2003 3:29 pm Post subject:

Knight

Joined: 15 May 2001
Posts: 540
Location: New Zealand

The XAResourceManager stanzas specify the databases that will be co-ordinated. The DB2INSTANCE environment variable must be set for the queue managers environment and specifies the DB2 instance that contains the databases. In our development environment development teams work with databases in their own DB2 instances but access a single queue manager. We therefore need our queue manager to be able to connect to databases in multiple instances and need to define a DB2INSTANCE variable that will allow this.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » IBM MQ Installation/Configuration Support » QM Connecting to Multiple DB2 Instances

Jump to:

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

Protected by Anti-Spam ACP