Securing the JDBC provider configurable service for the database stored procedures scenario

You secure the JDBC connection to a DB2® database by running the mqsisetdbparms command.

You must secure the JDBC connection to the DB2 database by completing the following steps:

1. Identify the user ID and password that you want to associate with the JDBC connection.

   In the scenario, user ID db2admin is used. Ask your database administrator for the user ID and password, and use these values for the userID and password variables. The user must have suitable permissions to read and create a stored procedure in the relevant database schema.

2. In the IBM® Integration Console, run the mqsisetdbparms command to associate the user ID and password with the security identity mySecurityId that is associated with the database.

   Run the following command:

   mqsisetdbparms IBNODE -n jdbc::mySecurityId -u userID -p password

   Where:

   • userID is your user ID (db2admin in the solution provided).
   • password is the password of the user ID.

   Tip: When you configured the JDBC provider configurable service, you set the securityIdentity parameter to mySecurityId. Now, you have associated the user ID and password with the configurable service.