Optimize 10.7 | webMethods Optimize Documentation | Administering webMethods Optimize | For Database Administrators | Configuring Optimize Database Pools | Defining Database Connection Pools
 
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 Products
* Installing Optimize Database Component Sets in this guide
You 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.