| Author |
Message
|
| martc |
 Posted: Thu Oct 25, 2007 9:47 am Post subject: DB username and password |
 |
|
Apprentice
Joined: 23 Mar 2005
Posts: 39
|
Configure the Database node as follows:
1. Specify in Data Source the name by which the appropriate database is known on the system on which this message flow is to execute. The broker connects to this database with user ID and password information that you have specified on the mqsicreatebroker, mqsichangebroker, or mqsisetdbparms command.
Is there a way around this? I dont have the option in my organization to dictate the userid and password for a DB I'm trying to connect to. This is provided by the DBA group and not an option for me. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Oct 25, 2007 9:54 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You don't need to put these anywhere in your flow.
You just need to have your broker administrator create an ODBC data source, and run mqsisetdbparms to associate a user name and password with that ODBC data source.
Any DBA that tells your broker administrator that they can't know what the user name or password is, has won the right to run the command themselves.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| martc |
| Posted: Thu Oct 25, 2007 10:10 am Post subject: |
|
|
Apprentice
Joined: 23 Mar 2005
Posts: 39
|
This solves my problem!
After getting the error 'invalid/password' and reading the documentation at first glance gave me the impression that the userid and password were fixed. I said to myself why put such constraints and sure enough there was none.
Thanks! |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Oct 25, 2007 10:18 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Well, they are fixed... until you run mqsisetdbparms again.
And if you *don't* issue mqsisetdbparms for a given ODBC datasource, then the BROKER DB user & password will be used...
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| rajmq |
| Posted: Thu Oct 25, 2007 11:47 am Post subject: |
|
|
Partisan
Joined: 29 Sep 2002
Posts: 331
Location: USA
|
Also, if broker & application both using the same database then mqsisetdbparams link is not required.
_________________
IBM Certified System Administrator - WebSphere MQ V6.0
IBM Certified System Administrator - WebSphere Business Integration Message Broker V6.0 |
|
| Back to top |
|
|
|
|
