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