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:
- Right-click either the database connection pool component in an
integration component library, or the shortcut to it a user project and select
Properties from the context menu.
- Select the database connection pool component in an integration component
library, or the shortcut to it a user project and do one of the
following:
- Select Component > Properties from the menu bar.
- Press Alt+Enter.
The following sections document the properties of database connection pools
and database connection objects that you can change:
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:
- Type the current password in the Old Password field.
- Type the new password in the New Password field.
- Type the new password again in the Confirm Password
field.
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.
Do the following to modify the maximum number of connections for a database
connection pool:
- Access the properties of the database connection pool you want to edit, as
described in Modifying database connection pools.
- 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:
- Type the maximum number of connections that should be established by the
pool in the Maximum connections field.
- Enable the Unlimited check box to allow as many connections to
be established as are permitted by the database server configuration and
licensing.
- Click OK.
Do the following to modify the maximum number of connections for a
connection object:
- Access the properties of the database connection pool you want to edit, as
described in Modifying database connection pools.
- 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.
- Type the new value in the Minimum connections field.
- Click OK.
Do the following to modify the database connection resilience settings for
a database connection pool:
- Access the properties of the database connection pool you want to edit, as
described in Modifying database connection pools.
- 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.
- Click OK.
Do the following to delete a database connection object:
- Access the properties of the database connection pool as described in Modifying database connection pools.
- In the "New Connection Pool" pane, right-click the connection
object you want to delete and select Delete from the context
menu.
- Click OK.
