Configure Database Parameters
CA Strong Authentication 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.
aa82test
CA Strong Authentication 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:
- Click theServices and Server Configurationstab in the main menu.
- Verify that the CA Strong Authentication tab in the submenu is active.
- Under the Instance Configurations section, click the Instance Management link to display the Instances page.
- Click the required instance link in the Instance Name column.The Instance name: <selected_instance> page appears.
- Edit the fields in the Database Configurations section, as required. The following table describes the fields of this section:
- Minimum ConnectionsDefine the minimum number of supported connections between CA Strong Authentication Server and the database when the server starts up.
- Maximum ConnectionsDefine the maximum number of supported connections between the CA Strong Authentication 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 byDefine the number of connections that to add 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 sleeps 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 checks the health of the connection pool for faulty database connections.
- Log Query DetailsEnable this option if you want to log the details for all database queries.
- Monitor Database ConnectivityEnable checking of the pools proactively in the database monitor thread.
- Auto-Revert to PrimaryEnable this option if you want the CA Strong Authentication Server to switch from the backup database to the primary database when the primary database becomes available again after a fail-over condition.
- ClickSave.
- Refresh the CA Strong Authentication Server instance for which you made the preceding changes.