ODBC driver connection, pool, pooling, and load balance parameters usage Policy Server

Products

• CA Single Sign-On
• SITEMINDER

Issue/Introduction

What is the meaning of ODBC driver parameters about connectivity:

Pooling
ConnectionReset
MaxPoolSize
MinPoolSize
LoadBalanceTimeout

as some are referred to the Siteminder documentation (1)?

Environment

Policy Server (All Versions)
DataDirect ODBC

Resolution

According to Progress DataDirect documentation, these parameters control the behavior of the driver’s internal connection pooling mechanism.

However, when used with the SiteMinder Policy Server, the following restriction applies:

[!CAUTION]

ConnectionReset is NOT supported.

Setting ConnectionReset=1 forces the driver to issue a "cleanup" command every time a connection is retrieved from the pool.
In high-transaction environments like a Policy Server, this adds significant overhead and can severely degrade performance.

This parameter must remain at the default (0).

Additional Information

1. How to Configure a MySQL Policy Store
   
   
2. DataDirect connection pooling
   
   
3. Configuring connection pooling