| Author |
Message
|
| rmbowma |
 Posted: Mon Aug 10, 2009 11:21 am Post subject: Appl database userid/password? |
 |
|
Apprentice
Joined: 24 Mar 2005
Posts: 28
|
I thought Broker was changed so that when you mqsicreatebroker, you can specify a userid/password that Broker will use to access its internal database and a different userid/password to access appl databases.
The Infocenter says the -u parm allows you to specify the user ID with which databases that contain broker tables and user data are to be accessed.
Am I understanding this correctly? I can NOT have separate userids/passwords for the Broker and appl databases? |
|
| Back to top |
|
 |
| PeterPotkay |
| Posted: Mon Aug 10, 2009 11:30 am Post subject: |
|
|
Poobah
Joined: 15 May 2001
Posts: 7722
|
When you create a Broker you only specify the ID / password to connect to the Broker's internal DB. Any ID / passwords needed by message flows to connect to application DBs are handled via a different command after the Broker is created and functional. Its possible, but not typical, for that application DB to be the same DB as the Broker's internal DB. Even in that case, it would still be a different command after the fact.
_________________
Peter Potkay
Keep Calm and MQ On |
|
| Back to top |
|
|
| rmbowma |
| Posted: Mon Aug 10, 2009 1:43 pm Post subject: |
|
|
Apprentice
Joined: 24 Mar 2005
Posts: 28
|
| What is the command to add a userid/pw for appl databases and the parms? I don't see it in Broker's reference manuals. |
|
| Back to top |
|
|
| Vitor |
| Posted: Mon Aug 10, 2009 2:38 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| rmbowma wrote: |
| I don't see it in Broker's reference manuals. |
You don't see any command (in the list of all commands that the InfoCentre provides) that allows you to set db parms? Like a command that allows you to set the security credentials for a data source name that is accessed from a message flow?
 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| rmbowma |
| Posted: Tue Aug 11, 2009 5:43 am Post subject: |
|
|
Apprentice
Joined: 24 Mar 2005
Posts: 28
|
You missed that. My bad. I'm aware of the mqsisetdbparms command and even looked at it. Write my goof off to being tired on Monday javascript:emoticon(' ') |
|
| Back to top |
|
|
|
|
