When Connection Pooling is enabled, at disconnect time, connections are stored in a dynamically sized "pool". The connection remains in the pool until it is either re-used, or the CONNECTIONPOOLINGTIMEOUT number of milliseconds has elapsed.
CONNECTIONPOOLING = 1
CONNECTIONPOOLING = 0 disables connection pooling;
CONNECTIONPOOLING= 1 enable connection pooling for all applications. This setting is only supported by systems that use TCP/IP.
CONNECTIONPOOLING= 2 signals that connection pooling is enabled, but only for the following specific applications:
CNXJDBC - Our JDBC Service
IISADMIN - Internet Information Server
ASPNET_WP - ASP.NET
INETINFO - Internet Information Server (used in debugging)
DLLHOST - Any COM/DCOM DLL based applications
SVCHOST - Any non-COM/DCOM DLL based applications
SQLSERVR - SQL Server
Note: When using Connection Pooling with Adabas, this timeout value must be smaller than any of the Adabas inactivity and ET timeout values, otherwise pooled connections could be timed out by Adabas and become invalid.
Default = 2
Environments: Client, Windows, Unix
Configuration Manager: CONNX Settings; Current Key = CONNX; Key Value/Value Name = ConnectionPooling
Unix Registry Setting: CONNX.CONNECTIONPOOLING