Defining Database Connection Pools
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:
Installing Software AG ProductsYou can perform this step before or after you define the webMethods 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
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.