Posted: Wed Nov 18, 2009 7:33 am Post subject: Changing WMB Service ID
Newbie
Joined: 18 Nov 2009 Posts: 2
I need to change the ID that WMB Broker runs under. The Broker was initially set-up with a ID/password in which the broker runs under and a separate dataname/ID/password for Oracle.
To change the broker service ID/password, I would use the following command...
My question is since there was a separate Oracle ID/password given during creation, will this command break the oracle connection? With looking at the mqsichangebroker command, there is a separate switch for the datasourcePassword but not the ID. I would think the above command would work and not impact Oracle, but I have no experience with this situation.
It is possible to have a userid/password for the broker that is different from the userid/password for the database. I've never done exactly what you describe, but I can't see why it wouldn't work. Be careful with which flags you use on the mqsichangebroker command. In particular:
-i = serviceUserId
-a = servicePassword (not -p)
So the command would be:
mqsichangebroker <brokername> -i <serviceID> -a <servicepassword>
You can use the mqsisetdbparms command to change the userid and password for connecting to the database.
Ideally you would try this out in a test/development environment before changing your production system.
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