What is the meaning of ODBC driver parameters :
Connection Pooling
Connection Reset
Max Pool Size
Min Pool Size
LoadBalance Timeout
as some are referred in the Siteminder documentation (1) ?
All Policy Server versions;
According to Progress documentation, those parameters to the
connection pooling feature (2)(3).
NOTE: Connection Reset is NOT supported because this parameter has
risk of impacting on Policy Server performance. So it shouldn't be set
to 1.
(1)
How to Configure a MySQL Policy Store
ConnectionReset=0
[...]
MaxPoolSize=100
MinPoolSize=0
Pooling=0
https://techdocs.broadcom.com/us/en/symantec-security-software/identity-security/siteminder/12-8/installing/install-a-policy-server/configure-odbc-databases-as-policy-session-key-and-audit-stores/configure-an-odbc-database-as-a-policy-store/how-to-configure-a-mysql-policy-store.html
(2)
DataDirect connection pooling
Connection pooling allows you to reuse connections rather than
creating a new one every time the driver needs to establish a
connection to the underlying database.
To configure the driver to use connection pooling:
Set the Connection Pooling (Pooling) option to 1.
Set the Connection Reset (ConnectionReset) option to 1 or 0. Setting
it to 1 resets the state of connections removed from the connection
pool for reuse by an application to the initial configuration of the
connection. Setting it to 0 does not reset the state of connections.
Set the Load Balance Timeout (LoadBalanceTimeout) option to specify an
integer value to specify the amount of time, in seconds, to keep
connections open in a connection pool.
Set the Max Pool Size (MaxPoolSize) option to specify an integer value
to specify the maximum number of connections within a single pool.
Set the Min Pool Size (MinPoolSize) option to an integer value to
specify the minimum number of connections that are opened and placed
in a connection pool when it is created.
[...]
Pooling=1
...
ConnectionReset=0
...
LoadBalanceTimeout=0
...
MaxPoolSize=100
...
MinPoolSize=0
https://docs.progress.com/bundle/datadirect-google-bigquery-odbc-80/page/DataDirect-connection-pooling.html
(3)
Configuring connection pooling
Connection Pooling
Specifies whether to use the driver’s connection pooling.
- If enabled, the driver uses connection pooling.
- If disabled, the driver does not use connection pooling.
Connection Reset
Determines whether the state of connections that are removed from the
connection pool for reuse by the application is reset to the initial
configuration of the connection. If enabled, the state of connections
removed from the connection pool for reuse by an application is reset
to the initial configuration of the connection. Resetting the state
can negatively impact performance because additional commands must be
sent over the network to the server to reset the state of the
connection. If disabled, the state of connections is not reset.
Max Pool Size
The maximum number of connections allowed within a single connection
pool. When the maximum number of connections is reached, no
additional connections can be created in the connection pool.
Min Pool Size
The minimum number of connections that are opened and placed in a
connection pool, in addition to the active connection, when the pool
is created. The connection pool retains this number of connections,
even when some connections exceed their Load Balance Timeout value.2
LoadBalance Timeout
Specifies the number of seconds to keep inactive connections open in
a connection pool. An inactive connection is a database session that
is not associated with an ODBC connection handle, that is, a
connection in the pool that is not in use by an application.
https://docs.progress.com/bundle/datadirect-oracle-service-cloud-odbc-71/page/Configuring-connection-pooling.html