Controls the behavior of client connection pooling.
Syntax
ConnectionPool={ NO | YES [ ( [ Timeout=timeout-sec; ] [
MaxCached=max-cached-conn ] ) ]
}
Usage
All platforms except non-threaded Unix clients.
Allowed Values
- timeout-sec – The idle timeout period, in seconds, of the connection pool. The default
value is 60 seconds. Cached connections that are not reused within the
time specified by the timeout-sec value are disconnected and are no
longer available for reuse.
- max-cached-conn – The maximum number of cached connections from each application. The
default value is five connections. A connection is cached if it is
disconnected and the maximum number of connections specified by the
max-cached-conn value has not been reached. The connection is
reinitialized, and the cached connection remains connected to the
database server even though the application has disconnected it.
Remarks
Connection pooling may improve the performance of applications that make multiple,
brief connections to the database server. When a connection is disconnected it is
automatically cached and may be reused when the application reconnects. For a
connection to be pooled, the connection name can be different, but all other
connection parameters must be identical.