| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| how to find out a database attached to broker |
« View previous topic :: View next topic » |
| Author |
Message
|
| reldb |
 Posted: Thu Nov 30, 2006 11:29 am Post subject: how to find out a database attached to broker |
 |
|
Apprentice
Joined: 06 Sep 2006
Posts: 34
|
When we create a new broker
mqsicreatebroker myBROKER —i mqsi —a password —q myBROKER_QM —n myDB —u myqsi -p password
Suppose we already have a broker and we want to find the information related to its database name and userid then how to check
Actually i want to create a new broker but using the previous broker database |
|
| Back to top |
|
 |
| prk |
| Posted: Thu Nov 30, 2006 11:38 am Post subject: |
|
|
Centurion
Joined: 17 Feb 2004
Posts: 102
|
mqsiservice {BrokerName}
gives all the details except the password because it is encrypted. |
|
| Back to top |
|
|
| JosephGramig |
| Posted: Thu Nov 30, 2006 11:54 am Post subject: |
|
|
Grand Master
Joined: 09 Feb 2006
Posts: 1244
Location: Gold Coast of Florida, USA
|
While using the same database if fine, you can run into issues. If you run both brokers with the same ID that is used to attached to the database, you will need to upgrade these brokers at the same time. This is only an issue if a fix or new release changes the tables. If you upgrade one, it will change the tables for it and the other broker.
This was an issue when upgrading from MQSI 2.1. It is not an issue if the brokers are created with different schemas or different databases. The schema is derived from the ID that is connecting to the database (I like to use the same ID that runs the broker).
I would run each broker with a unique service ID.
_________________
Joseph
Administrator - IBM WebSphere MQ (WMQ) V6.0, IBM WebSphere Message Broker (WMB) V6.1 & V6.0
Solution Designer - WMQ V6.0
Solution Developer - WMB V6.1 & V6.0, WMQ V5.3 |
|
| Back to top |
|
|
| reldb |
| Posted: Thu Nov 30, 2006 12:30 pm Post subject: |
|
|
Apprentice
Joined: 06 Sep 2006
Posts: 34
|
thanks
this info was good for me |
|
| 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
|
|
|
|
