9.5.3 Configuring DB2 database connectivity

To enable WebLogic Server and your LiveCycle deployment to connect to the DB2 database, you must create a database connection for WebLogic Server by setting up a connection pool and a data source.

Create a new data source for DB2 on WebLogic 11g

  1. Start the WebLogic Administration Console by typing http://[hostname]:[port]/console in the URL line of a web browser.

  2. Type the user name and password that you created for the WebLogic Server domain and click Log In.

  3. Under Change Center, click Lock & Edit.

  4. Under Domain Structure, click Services > JDBC > Data Sources and, in the right pane, click New.

  5. On the next screen, set the following properties:

    • In the Name box, type IDP_DS.

    • In the JNDI name box, type IDP_DS.

    • In the Database Type list, select DB2.

    • In the Database Driver list, select IBM’s DB2 Driver (Type 4) for JDBC and SQLJ; Versions: 8.x; 9.x

  6. Click Next and select Supports Global Transactions and Emulate Two-Phase Commit.

  7. Click Next and, on the next screen, define the following properties that apply to the database you created during your LiveCycle install preparations:

    Database Name: The name of the database you have created

    Host Name: The name or IP address of the computer on which DB2 is running

    Port: Database port. The default is 50000

    Database User Name: The name of the user you created on the DB2 database

    Password and Confirm Password: The password associated with the user

  8. Click Test Configuration to verify the configuration settings.

    Note: If the test is successful, a “Connection test succeeded” message appears. Click Next. Otherwise, review the error message that appears and modify the settings as required until the test succeeds.
  9. On the next screen, select the server that the data source will connect to (in this case, the managed server).

  10. Click Finish and Activate Changes.

Configure the connection pool settings

  1. Under Domain Structure, click Services > JDBC > Data Sources and, in the right pane, click IDP_DS.

  2. On the next screen, click the Configuration tab > Connection Pool tab.

  3. In the Maximum Capacity box, type 30.

  4. In the Statement Cache Size box, type 80.

  5. Click Save and thenclick Activate Changes.

  6. Restart WebLogic managed server.

Create a new data source for DB2 for Rights Management on WebLogic 11g

Note: This procedure applies only if you installed Rights Management.
  1. Under Change Center, click Lock & Edit.

  2. Under Domain Structure, click Services > JDBC > Data Sources and, in the right pane, click New.

  3. On the next screen, set the following properties:

    • In the Name box, type RM_DS.

    • In the JNDI Name box, type EDC_DS.

    • In the Database Type list, select DB2.

    • In the Database Driver list, select IBM’s DB2 Driver (Type 4) for JDBC and SQLJ; Versions: 8.x; 9.x

    • Click Next and select Supports Global Transactions and One-Phase Commit.

  4. Click Next and define the following properties that apply to the DB2 database you created during your LiveCycle install preparations:

    Database Name: The name of the database you have created

    Host Name: The name or IP address of the computer on which DB2 is running

    Port: Database port. The default is 50000

    Database User Name: The name of the user you created on the DB2 database

    Password and Confirm Password: The password associated with the user

  5. Click Test Configuration to verify the configuration settings.

    Note: If the test is successful, a “Connection test succeeded” message appears. Click Next. Otherwise, review the error message that appears and modify the settings as required until the test succeeds.
  6. On next screen, select the server that the data source will connect to (in this case, the managed server).

  7. Click Finish and Activate Changes.

Configure the connection pool settings

  1. Under Domain Structure, click Services > JDBC > Data Sources and, in the right pane, click RM_DS.

  2. On the next screen, click the Configuration tab > Connection Pool tab.

  3. In the Maximum Capacity box, type 20.

  4. In the Statement Cache Size box, type 80.

  5. Click Save and then click Activate Changes.

  6. Restart WebLogic managed server.

// Ethnio survey code removed