| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Can a broker access more than one database? |
« View previous topic :: View next topic » |
| Author |
Message
|
| rmah |
 Posted: Fri Jun 01, 2007 1:49 pm Post subject: Can a broker access more than one database? |
 |
|
Centurion
Joined: 04 May 2007
Posts: 142
|
Hi,
This may be a silly question...
I created a broker with the following command:
mqsicreatebroker WBRK6_DEFAULT_BROKER -i mqm -a mqm -q WBRK6_DEFAULT_QUEUE_MANAGER -n <db alias> -u <db uid> -p <db pass> –t
Where db alias is specified in the .odbc.ini file.
Is it possible to to specify a second databse in the .odbc.ini file, and have the broker connect more than one database that stores application data which I need to process messages within our flows ?
Last edited by rmah on Fri Jun 01, 2007 2:08 pm; edited 1 time in total |
|
| Back to top |
|
 |
| marcin.kasinski |
| Posted: Fri Jun 01, 2007 2:02 pm Post subject: Re: Can a broker access more than one database? |
|
|
Sentinel
Joined: 21 Dec 2004
Posts: 850
Location: Poland / Warsaw
|
| rmah wrote: |
Is it possible to to specify a second databse in the .odbc.ini file, and have the broker connect to TWO databases?
Or can the broker only access one database at a time, and I would have to setup a new broker if I want to access another database? |
Are you talking about database to store internal broker informations or database to store application data which you need to process messages within your flows ?
If it is option 1 -> it is not possible. Why would you need second database ?
If it is option 2 -> you can use any databases from odbc.ini supported by Broker
_________________
Marcin |
|
| Back to top |
|
|
| rmah |
| Posted: Fri Jun 01, 2007 2:09 pm Post subject: Re: Can a broker access more than one database? |
|
|
Centurion
Joined: 04 May 2007
Posts: 142
|
| marcin.kasinski wrote: |
| rmah wrote: |
Is it possible to to specify a second databse in the .odbc.ini file, and have the broker connect to TWO databases?
Or can the broker only access one database at a time, and I would have to setup a new broker if I want to access another database? |
Are you talking about database to store internal broker informations or database to store application data which you need to process messages within your flows ?
If it is option 1 -> it is not possible. Why would you need second database ?
If it is option 2 -> you can use any databases from odbc.ini supported by Broker |
Thanks. I've modified my original message. Yeah, I'm edulding to option 2. Would I simply add another entry into the .odbc.ini file? Would I have to change anything in the broker via toolkit or cmd line? |
|
| Back to top |
|
|
| marcin.kasinski |
| Posted: Fri Jun 01, 2007 2:42 pm Post subject: Re: Can a broker access more than one database? |
|
|
Sentinel
Joined: 21 Dec 2004
Posts: 850
Location: Poland / Warsaw
|
|
| 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
|
|
|
|
