Policy Server ODBC driver connection pooling parameters meaning
search cancel

Policy Server ODBC driver connection pooling parameters meaning

book

Article ID: 98921

calendar_today

Updated On:

Products

CA Single Sign On Secure Proxy Server (SiteMinder) CA Single Sign On SOA Security Manager (SiteMinder) CA Single Sign-On SITEMINDER CA Single Sign On Federation (SiteMinder)

Issue/Introduction

 

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) ?

 

Environment

 

All Policy Server versions;

 

Resolution

 

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.

 

Additional Information

 

(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