MQSeries.net :: View topic - WMB : DSN directory with mqsisetdbparms for ODBC credentials

zpat · Posted: Thu Mar 19, 2015 5:24 am Post subject:

WMB (IIB) uses a DSN directory in the registry to hold credentials.

Originally these were just for ODBC and subdirectories were created by the mqsisetdbparms command (e.g. FRED for Data Source Name FRED).

However later versions of WMB added new types of credential so that directories can now be found with names like sftp::JOHN or jdbc::MIKE.

What is confusing me is that sometimes I see directories named FRED and odbc::FRED

This would appear to be due to use of the command in two formats

mqsisetdbparms <broker> -n FRED -u xxx -p yyy
and
mqsisetdbparms <broker> -n odbc::FRED -u xxx -p yyy

These both set ODBC credentials - however my question is what happens if someone has done both for the same DSN, which credentials does the EG use?

Is there a precedence order, and can I safely remove one of these directories?

Also can I go around renaming the old name format to the new format for consistency (or vice versa) without breaking anything?

Also we had an interesting situation whereby the mqsicvp command worked when testing an ODBC data source, but the EG failed to open it. Was resolved when both formats of the mqsisetdbparms were issued. Suggesting that the mqsicvp command does not use the same credential logic as the EG code.
_________________
Well, I don't think there is any question about it. It can only be attributable to human error. This sort of thing has cropped up before, and it has always been due to human error.