Steps for managing database connection pools

At run time, it takes time for processes to establish new connections to the database. You can minimize that time by establishing database connection pools for use by your collaboration and map processes.

Use of database connection pools requires establishing pool names in collaboration template and map code, in addition to creating the database connection pools in System Manager. For instructions on performing those tasks, and additional information about setting up database connection pools, see the System Implementation Guide.

Perform the following steps to manage how the database connection pool resources are allocated to your collaboration and map processes (if database connection pools have been set up on your system):

  1. Revise the number of connection processes that can be used by a specific database connection manager and its pools.
  2. Revise the database connection pool assignments.

For details about these tasks, see the System Implementation Guide.

Copyright IBM Corp. 2004, 2005