MQSeries.net :: View topic - Multiple Brokers and dat sources

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 » WebSphere Message Broker (ACE) Support » Multiple Brokers and dat sources

Multiple Brokers and dat sources

« View previous topic :: View next topic »

Author

Message

lanny boy

Posted: Tue May 03, 2005 2:18 am Post subject: Multiple Brokers and dat sources

Voyager

Joined: 24 Nov 2003
Posts: 79
Location: UK

My development and test brokers are present on the same windows box.

At present both brokers access the same DB2 tables. I want to be able to seperate the datasources so the DEV broker updates a a DEV data source and Test updates a test datasource.

I want to keep the same table names on both so that code does not have to be changed when moving form test to DEV.

I'm pretty sure this can be done but am unsure exactly how! I think that be creating the databases/brokers under different profiles may be the solution, but when i try this i get errors saying a table of name 'X' already exists. I have also tried using common Aliases but this throws the same error.

Has anyone any ideas.

Thnaks
Lanny Boy

Ian

Posted: Tue May 03, 2005 6:18 am Post subject:

Disciple

Joined: 22 Nov 2002
Posts: 152
Location: London, UK

The mechanism that WMQI v2.1 and WBIMB v5.0 provides for dealing with different user environments (such as DEV, TEST and PROD) is through promoted node properties. You can promote the DSN and then override this at the flow level as opposed to each individual node. For further information on this topic refer to the v2.1 or v5.0 manuals.
_________________
Regards, Ian

Tibor

Posted: Tue May 03, 2005 7:11 am Post subject:

Grand Master

Joined: 20 May 2001
Posts: 1033
Location: Hungary

Quote:

I'm pretty sure this can be done but am unsure exactly how! I think that be creating the databases/brokers under different profiles may be the solution, but when i try this i get errors saying a table of name 'X' already exists. I have also tried using common Aliases but this throws the same error.

On AIX I created different users for environments with own ODBC settings. There is two databases but in this case the DSNs are same and the modifying of msgflows not needed.

Tibor

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Multiple Brokers and dat sources

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