| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Multiple Brokers on same machine |
« View previous topic :: View next topic » |
| Author |
Message
|
| JTELFORD |
 Posted: Wed Feb 13, 2002 4:52 am Post subject: |
 |
|
Newbie
Joined: 12 Feb 2002
Posts: 6
Location: Yeovil, England
|
Wondering if anyone can help......
I have a DEV and SIT environment with one Config Manager for each environment. My brokers are currently on separate AIX boxes, but I want to move these onto a single machine. In my MQSI flows, I access an application database, which varies slightly between environments. If I were to move both DEV and SIT brokers onto same AIX box, is there any way I can reference the two different application databases, but keep the same alias name. Does anyone know when the broker accesses the databases - i.e. when the broker is created, started or when it processes the messages.
any help on this one would greatly be appreciated - thanks.........Jacky |
|
| Back to top |
|
 |
| amigupta1978 |
| Posted: Wed Feb 13, 2002 10:05 am Post subject: |
|
|
Centurion
Joined: 22 Jan 2002
Posts: 132
Location: India
|
Hi,
the database is referred in the MQSI using the ODBC names. In the case of the AIX broker that name is there in the .odbc.ini file so if u want to use 2 different databases define there odbc names in the .odbc.ini file.
And MQSI broker uses the userid permissions which u give while creating the broker (just see the mqsicreatebroker command)
amit |
|
| Back to top |
|
|
| GYR |
| Posted: Fri Feb 15, 2002 2:33 am Post subject: |
|
|
Acolyte
Joined: 23 Jan 2002
Posts: 72
|
Hi Jacky,
In addition to what amit has written the alias as far as I am aware is the means by which the database is accessed not necessarily its actual name and therefore if you had 2 DBs that are different then you will need two aliases, as there would be confusion having the same alias for 2 different DB's as the alias obviuosly relates to the database. What you can do however if you only have the one flow is to use the propagate function within the node and pass the DB name etc you want to access to the node in what is in effect a run time type scenario. Hope this helps...... Kev.
[ This Message was edited by: GYR on 2002-02-15 02:40 ] |
|
| Back to top |
|
|
| JTELFORD |
| Posted: Wed Feb 20, 2002 7:50 am Post subject: |
|
|
Newbie
Joined: 12 Feb 2002
Posts: 6
Location: Yeovil, England
|
Hi again!
Thanks for your help Kev.......
In the MQSI for AIX Installation guide, it mentions setting an environment variable ODBCINI to the location of the .odbc.ini file for the broker. So, by setting this in the .profile for each broker user and only ever starting the broker from one UNIX user, we can ensure the ODBCINI value is set to point to the correct file every time the broker is started. Will be implementing this next week and will let you know the result, but am hopeful this will work - thanks again for your help, Jacky |
|
| 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
|
|
|
|
