Usingthe asadmin commands to change connection pool properties.

Youcan use the asadmin get and set commands to view and change the values of the
connectionpool properties.
Tolist all the connector connection pools in the server:
asadminlist domain.resources.connector-connection-pool.*
Toview the properties of the connector connection pool, you can use the following command:
asadminget domain.resources.connector-connection-pool.conectionpoolname.*
Toset a property of the connector connection pool, you can use the following command:
asadminset
domain.resources.connector-connection-pool.conectionpoolname.pool-resize-quantity=3

▼ToEdit Connector Connection Pool Advanced

Attributes
Usethe Advanced tab to edit the advanced attributesfor a connector connection pool.
Parameter Description
ValidateAtmost Once Amountof time, in seconds, after which a connection is validated at most once.
Thiswill help reduce the number of validation requests by a connection. The
defaultvalue 0 implies that connection validation is not enabled.
LeakTimeout Amountof time, in seconds, to trace connection leaks in a connection pool. The
defaultvalue 0 means that connection leak tracing is disabled. If connection leak
tracingis enabled, you can get statistics on the number of connection leaks in the
MonitoringResources tab. To view this tab, go to Application Server > Monitoring
>Resources.
LeakReclaim If this option is enabled, leaked connections will be restored to the pool after leak
connectiontracing is complete.
CreationRetry Attempts Numberof attempts that will be made if there is a failure in creating a new
connection.The default value of 0 implies that no attempts will be made to create
theconnection again.
RetryInterval Specifythe interval, in seconds, between two attempts to create a connection. The
defaultvalue is 10 seconds. This attribute is used only if the value of Creation
RetryAttempts is greater than 0.
MoreInformation
1
ManagingConnectorConnection Pools
Chapter7 • Connector Resources 85