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.