A database connection pool consists of a number of reserved
database connections. The reserved database connections are made
available only to the collaboration and map processes that you design
to use the pool.
To create a database connection pool, you define the values necessary
for making a database connection beforehand. The integration system
saves this database connection information and uses it at runtime
to more quickly establish connections for collaboration and mapping
processes that you have assigned.
The configuration of database connection values that you define
can be used by one or more pools. For each pool you will specify
a number of connections; these connections will be allocated, used,
and freed back to the pool.
Note:
It is recommended that you connect to the InterChange
Server Express instance that will use the database connection pool
in System Manager before you create the pool, so that you can validate
the connection.
Do the following to create a database pool:
- Right-click the Database Connection Pools folder
in your integration component library in System Manager and choose Create New Database Connection from
the context menu.
The "Database Connection" dialog appears.
Note:
Although the name of the dialog would suggest
that what you are creating at this point is a database connection,
it is really a database connection pool. In later steps you will
define database connections within the pool.
- Select the appropriate value in the Database Driver drop-down
menu--either DB2 (Type 2) or MQ SQL Server(Type 4)or DB2 iSeries(Type 2) --depending on the database vendor or IBM Toolbox
for iSeries (Type 4) if you are using i5/OS with a remote repository
database.
- If you chose MQ SQL Server(Type 4)in the Database Driver drop-down menu,
then you must type the name of the computer on which the database
server resides in the Host name field.
If you chose DB2 iSeries (Type 2) in the Database Driver drop-down menu,
then you must enter the OS/400 system host name where the database
resides in the Host name field.
- Type the name of the database in the Database field.
If you chose DB2 iSeries (Type 2) in the Database Driver drop-down menu,
you will see Schema instead of Database for
the field name. Specify the database schema name for this connection
(that is, the collection name).
- If you chose MQ SQL Server(Type 4)in the Database Driver drop-down menu,
then you must type the port number through which clients communicate
with the database server in the Port number field.
- If you are connected to the InterChange Server Express instance
that will use the pool, select that instance from the Connected Servers drop-down
menu.
- Type a name for the pool in the DBConnection Name field.
You specify this database connection pool name when writing Java
code to establish the connection in maps or collaboration templates.
- Type the user name that should be used by InterChange Server
Express to log in to the specified database in the Login field.
If you chose DB2 iSeries (Type 2) in the Database Driver drop-down menu,
this field should be a valid user profile on the OS/400 machine,
and the profile must also have the proper authority for the database and
database objects. Further, if the Login and
corresponding password field is blank, then
the user profile of the InterChange Server Express job (by default, QWBISVR44) will be used for database access.
- Type the password for the user name.
- Type the maximum number of connections that should be established
by the pool for all the individual database connection objects you
plan to create within it in the Maximum connections field,
or enable the Unlimited checkbox to allow
as many connections to be established as are permitted by the database server
configuration and licensing.
Warning:
Be careful when working in this field. It is not a single-line
text field, even though it should be, so you can accidentally press Enter.
You will not see the value you entered then, and will justifiably
try to re-type the value. Then when you try to finish creating the
database connection pool you receive an error that a valid value
must be entered for the field. Do not press Enter in
this field.
Figure 39 shows the "New
Database Connection Pool" wizard.
Figure 39. Create New Database Connection wizard
- To create a new database connection object in the pool, right-click
a row in the New Connection Pool table at
the bottom of the wizard and choose New Connection Pool from
the context menu.
Note:
Although the interface would suggest that what
you are creating at this point is also a database connection pool,
it is really a database connection object that you are creating
within the pool you just created.
The "Connection Pool" dialog appears.
- Type a name for the database connection object in the Name field.
- In the Minimum connections field, enter
the minimum number of connections that the database connection object
should establish. Note that the sum of the minimums for all the
pools that you create in pool cannot exceed the maximum number that
you specify for the database connection pool object itself. System
Manager does not allow you to attempt to add a connection object
or modify an existing connection object so that the maximum number
of connections for the pool would be exceeded. Figure 40 shows the "Connection Pool" dialog.
Figure 40. "Connection Pool" dialog
- Click Finish.
System Manager saves the database connection pool object and
an icon appears under the Database Connection Pools folder
in the integration component library.
- Use the wizard to create another database connection pool at
this time or click Cancel to close the wizard.
