Securing database connections
Set up security for a database connection, whether it is required by the database provider or optional.
Before you begin
- If you are using a JDBC provider, you must first set up the JDBC provider. See Set up your JDBC provider definition.
- If you are using an ODBC connection, you must first connect to the database. See Enabling ODBC connections to the databases.
About this task
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:
- On Windows: The integration node service ID and password that you specified on the mqsicreatebroker command.
- On Linux® and UNIX: The user ID
mqsiUser
and password********
(these values are fixed). - On z/OS®: The user ID
""
and password""
, which causes the connection to be made with the broker started task user ID.
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.
ODBC connections
About this task
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: