We have an MQ broker that's trying to run procedures in a number of
our DB2 databases. The MQ guy is telling me that I have to create a
login on each DB2 box that matches, both username & password, the
username and password that the MQ broker was started with on the MQ
box.
While that does work (ie: allows the broker to run the procedure) it
seemed like we should be able to specify a different username/password
for each DB2 box that MQ needs to talk to. The MQ guy tried
specifying the username and password in the ODBC.ini file, but it
still attempted to log in with the username that started the broker on
the MQ box.
Is there some way to have the MQ broker use a different username/
password for each DB2 instance that it connects to? If that's
possible, is there some way to securely do it? The password he put in
the ODBC.ini file is not encrypted.
Thanks.
Richard