CA Strong Authentication Administration Guide › Managing CA Strong Authentication Server Instances › Set Up Server Instances › Configure Database Parameters

Configure Database Parameters

CA AuthMinder uses connection pooling, to avoid the overhead of establishing a new database connection each time the server requires access to the database. By using the instance-specific page, you can configure these connection pooling parameters for the instance. The data that is displayed on the Instance Statistics page depends on the parameters that are configured on this page.

Follow these steps:

1. Click the Services and Server Configurations tab in the main menu.
2. Verify that the CA Strong Authentication tab in the submenu is active.
3. Under the Instance Configurations section, click the Instance Management link to display the Instances page.
4. Click the required instance link in the Instance Name column.

   The Instance name: <selected_instance> page appears.

5. Edit the fields in the Database Configurations section, as required. The following table describes the fields of this section:

   Minimum Connections

   Define the minimum number of supported connections between CA AuthMinder Server and the database when the server starts up.

   Maximum Connections

   Define the maximum number of supported connections between the CA AuthMinder Server and the database.

   Note: You set this value depending on the maximum connections that the database supports, because this parameter overrides the MaxConnections parameter. See your database vendor documentation for more information.

   Increment Connections by

   Define the number of connections that will be added to the existing connections at a time,.

   Important! The total number of connections cannot exceed the maximum number of connections.

   Monitor Thread Sleep Time (in Seconds)

   Specify the time for which the monitoring thread will sleep between successive heartbeat checks for all databases.

   Monitor Thread Sleep Time in Fault Conditions (in Seconds)

   Specify the interval at which the database monitor thread will check the health of the connection pool in case of faulty database connections.

   Log Query Details

   Enable this option if you want to log the details for all database queries.

   Monitor Database Connectivity

   Enable checking of the pools proactively in the database monitor thread.

   Auto-Revert to Primary

   Enable this option if you want the CA AuthMinder Server to switch from the backup database to the primary database when the primary database becomes available again after a failover condition.

6. Click Save.
7. Refresh the CA AuthMinder Server instance for which you made the preceding changes. See Refresh a Server Instance for instructions on how to do this.instructions about how to achieve this.