| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Help Needed - Broker DB userid change |
« View previous topic :: View next topic » |
| Author |
Message
|
| vmurali_au |
 Posted: Tue Aug 03, 2004 6:02 am Post subject: Help Needed - Broker DB userid change |
 |
|
Voyager
Joined: 26 Mar 2004
Posts: 76
|
We are using MQ Series Integrator 2.1 for AIX. The Config Manager is in a separate NT box.
The problem is, we have to change the database userid & password for broker's MQSIBKDB connection. Currently it is configured as using user "db2inst1".
Now, we have to use the userid "mqsi" for MQSIBKDB connection. "mqsi" is already given the sufficient group priveleges.
The Broker is already deployed in the production environment.
Using the changebroker command, i could only find that we can only change the MQSIBKDB DB connection password and not the DB userid.
Is there anyway by which we can change the DB userid for Broker Database, without deleting the Current Broker. If we have to delete the broker, then we have to again go through the pains of redeploying the message flows etc.
Any help in this context would be really helpful.
Thanks a lot in advance. |
|
| Back to top |
|
 |
| JT |
| Posted: Tue Aug 03, 2004 6:40 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Never tried this myself, but you may be able to simply edit the file that stores the broker database id. On a v5.0 Solaris platform its located in /var/mqsi/registry/Broker/DataSourceUserId. |
|
| Back to top |
|
|
| waugh |
| Posted: Tue Aug 03, 2004 10:01 am Post subject: |
|
|
Master
Joined: 19 Feb 2004
Posts: 225
|
did u look at the mqsichangebroker command?
Never tried, but i read using that command you can change DB user id for broker. |
|
| Back to top |
|
|
| JT |
| Posted: Tue Aug 03, 2004 10:29 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
muros was correct when he/she stated that the mqsichangebroker command did not expose the -u parameter.
| Quote: |
mqsichangebroker brokername <<-i ServiceUserID> -a ServicePassword>
<-p DatabaseSourcePassword> <-s UserNameServerQueueManagerName>
<-t | -n> <-l UserLilPath> <-g ConfigurationTimeout>
<-k ComfigurationDelayTimeout> |
From the v2.1 Administration Guide:
| Quote: |
If you want to change the user ID through which a broker accesses its database
tables (the DataSourceUserID parameter on the mqsicreatebroker command or the
Command Assistant), you must:
1. Back up the database tables
2. Back up the workspace, by saving it from the Control Center and backing up the
XML document created by the export.
3. Backup the message sets stored in the message repository
4. Stop the broker using the mqsistop command.
5. Delete the broker
6. Restore the database tables to the new location.
7. Recreate the broker specifying the new user ID on the mqsicreatebroker
command or the Command Assistant. |
|
|
| 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
|
|
|
|
