The following table summarizes all the options that you need to create connection pools with the create -r command option.
Table A–8 Create connection pool parameters|
Parameter |
Value |
|---|---|
|
poolname jdbcpoolname |
The pool name for the JDBC connection pool. |
|
classname classname |
The vendor-specific classname that implements the data source. |
|
steadypoolsize steadypoolsize |
The minimum number of connections that must be maintained in the pool |
|
maxpoolsize maxpoolsize |
The maximum number of connections allowed in the pool. |
|
poolresizequantity poolresizequantity |
The size of the batch by which the pool is resized when the steadypoolsize value is approached. |
|
idletimeout idletimeout |
The maximum time in seconds that a connection can remain idle in the pool. |
|
maxwaittime maxwaittime |
The amount of time the caller will wait before getting a connection timeout. |
|
connectionvalidation true/false |
Specifies whether connections will be validated before they are passed to the application. |
|
connectionvalidationmethod connectionvalidationmethod |
The methods that can employ to validate database connections. Legal values are auto-commit, meta-data, and table. |
|
validationtablename validationtablename |
The name of the table if connectionvalidationmethod is set to table. |
|
failall true/false |
Specifies whether to fail all connections in the pool and re-establish them if a single connection is determined to have failed. |
|
desc description |
The description of the pool. |
|
property propertyname=value |
The name-value pairs that specify standard and proprietary JDBC connection pool properties |