| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Accessing multiple Databases from one broker in WMQI 2.1 |
« View previous topic :: View next topic » |
| Author |
Message
|
| MQ_MQSI_User |
 Posted: Tue Mar 23, 2004 11:32 am Post subject: Accessing multiple Databases from one broker in WMQI 2.1 |
 |
|
Novice
Joined: 11 Jul 2002
Posts: 20
Location: Charlotte, NC
|
Is it possible to access multiple databases from one broker. It's my understanding that when you create the broker, in the odbc.ini file you point to a database. Once that's created you can only connect to that db's or other db's on that same server. In the compute node you can change the datasource and table you are going to but that's it. You cannot goto another DB that is not referenced in your initial odbc configuration.
Does this differ on z/OS?
_________________
MQSeries, MQSI |
|
| Back to top |
|
 |
| EddieA |
| Posted: Tue Mar 23, 2004 2:03 pm Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
Yes.
| Quote: |
| another DB that is not referenced in your initial odbc configuration |
So, add it.
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| MQ_MQSI_User |
| Posted: Tue Mar 23, 2004 4:12 pm Post subject: |
|
|
Novice
Joined: 11 Jul 2002
Posts: 20
Location: Charlotte, NC
|
So you are saying I can simply add the additional odbc entry to the odbc.ini file and wmqi will make an additional odbc connection to that db. This sounds specific to Distributed systems.
On the z/OS what is comperable to the odbc.ini file?
Our environment is: WMQI 2.1, z/OS broker, remote app DB2 database.
_________________
MQSeries, MQSI |
|
| 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
|
|
|
|
