Defining Database Connection Pools

Edit online

Before you begin

Before you configure Optimize database connection pools, the Optimize database component sets should be installed in one or more database schemas. For instructions, see the following:

About this task

You can perform this step before or after you define the IBM webMethods BPM Optimize environment.

Note: You cannot complete the definition of an environment until you have defined database connection pools and mapped them to Optimize database activities.

To define database connection pools

Procedure

  1. In My webMethods: Navigate > Applications >Administration > System-Wide > Environments > Database Pool Configuration.
  2. Click Add Pool.

    The Database Pool Configuration page displays fields for defining pool information, a database connection, and pool settings.

  3. Type a name for the new database connection pool in the Name text box.

    If you are defining four database pools, you might name them Analysis, ProcessTracker, ProcessAuditLog, and MywebMethodsServer.

  4. Type a description of the database connection pool in the Description text box.

    You might describe the purpose of the database connection pools and the location of the database schema and Optimize database activity or activities that the pool is connecting.

  5. Select the RDBMS from the drop-down list.
  6. Type the URL to the database schema containing one or more Optimize database component sets in the URL text box.
    The RDBMS-specific format for the URL appears in the text box.
    Important: For DB2, you must add the following additional options to the URL: AlternateID=<schema_name>;showSelectableTables=false   Here is the sample format with the two additional options: jdbc:wm:db2://<server-name-or-IP-address>:<port>; (DatabaseName=<database-name>|LocationName=<location-name>) [;AlternateID=<schema_name>;showSelectableTables=false]   The < schema_name > parameter must be capitalized.

    For more information, see the Configuring BAM PDF publication.

  7. Type the database user and database password in the corresponding fields.
  8. Inspect the default pool settings and make changes as needed.
    The following table lists the recommended values of the database pool settings for Optimize.
    Database pool setting Recommended value
    Minimum Connections 4
    Maximum Connections 18
    Idle Connection Timeout 20 seconds
    Ramp-up Delay 500 milliseconds
    Connection Tries 8
    Retries Backoff 500 milliseconds
    Allow Statement Caching no (unchecked)

    For more information, see the Configuring BAM PDF publication.

  9. Click Save.
  10. Repeat the above steps for each new database connection pool.