Set up security for a database connection, whether it is required by the database provider or optional.
Use the mqsisetdbparms command to specify a user ID and password that the integration node can use to access each database. If a user ID and password have not been specified for database access using the mqsisetdbparms command, default values for user ID and password are used which are platform specific:
If you migrated your integration node from WebSphere® Message Broker Version 6.1, the integration node accessed a database for its own use. You might have defined the user ID and password used to access that database by specifying a database connection user ID and password with the -u and -p parameters on the mqsicreatebroker command. Alternatively, you might have used the integration node service user ID and its password (specified with the -i and -a parameters on the same command). When you migrate the integration node, these parameters are migrated and stored, and are used by the migrated integration node for access to databases that do not have specific ID access defined. If you want to check what user ID you set, or test that the password for a specific user ID is what you expect, you can use the mqsireportdbparms command.
If your ODBC data source requires you to define secure access, or if you want to implement security where this is optional, complete the following steps: