Modifying database connection pools

You can modify some properties of both database connection pools and database connection objects.

To modify a database connection pool, do one of the following:

The following sections document the properties of database connection pools and database connection objects that you can change:

Modifying login information

Many companies follow a practice of changing passwords at a regular interval to guard against old accounts being used to violate security. If this is the case at the site then you may need to change the login information for the database connection pool.

To change the login name used to access the database resource, type the new value into the Login field in the "Database Connection" screen.

To change the password for the specified login, click Change in the "Database Connection" screen, then do the following at the "Password Change" prompt:

  1. Type the current password in the Old Password field.
  2. Type the new password in the New Password field.
  3. Type the new password again in the Confirm Password field.

Modifying the number of connections

You can modify the maximum number of connections for a database connection pool, and the minimum number of connections for a database connection object. The sum of all the minimum connections of all the database connection objects defined in a database connection pool may not exceed the maximum number of connections specified for the pool itself.

Modifying the maximum connections for a database connection pool

Do the following to modify the maximum number of connections for a database connection pool:

  1. Access the properties of the database connection pool you want to edit, as described in Modifying database connection pools.
  2. Do one of the following to modify the maximum number of connections that can be established by the total number of connection objects in the pool:
  3. Click OK.

Modifying the minimum connections for a database connection object

Do the following to modify the maximum number of connections for a connection object:

  1. Access the properties of the database connection pool you want to edit, as described in Modifying database connection pools.
  2. In the "New Connection Pool" pane, right-click the connection object for which you want to change the minimum number of connections and select Edit from the context menu.
  3. Type the new value in the Minimum connections field.
  4. Click OK.

Modifying database connection resilience settings

Do the following to modify the database connection resilience settings for a database connection pool:

  1. Access the properties of the database connection pool you want to edit, as described in Modifying database connection pools.
  2. Type in the number of times you would like the WebSphere InterChange Server to try to regain a database connection when the connection is broken or cannot be established in the Maximum connect retries field. In the Connect retry interval field, enter the amount of time (in seconds) that you would like InterChange Server to wait between two attempts to regain the database connection.
  3. Click OK.

Deleting database connection objects

Do the following to delete a database connection object:

  1. Access the properties of the database connection pool as described in Modifying database connection pools.
  2. In the "New Connection Pool" pane, right-click the connection object you want to delete and select Delete from the context menu.
  3. Click OK.

Copyright IBM Corp. 1997, 2004