Securing the JDBC Providers policy for the database stored procedures scenario

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

About this task

A DB2 database requires a data source login name and password on all connections.

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® App Connect Enterprise 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.

Results

You secured the JDBC connection.

What to do next

Follow the steps in Testing your solution.