Previous Topic: Tables That Do Not Need SynchronizationNext Topic: Configuring Alternate Schema for IBM DB2 Universal Database


Database Tuning Parameters

The following table lists the common parameters that you can use to tune the connection between AuthMinder Server and the database. These configurations are made using the Instance Management screen of the Administration Console.

Field

Description

Minimum Connections

Enter the minimum number of connections that will be created between AuthMinder Server and the database when the server starts up.

Maximum Connections

Enter the maximum number of connections that can be created between the AuthMinder Server and the database.

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

Increment Connections By

Enter the number of connections that will be added to the existing connections at a time, when the need arises.

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

Monitor Thread Sleep Time (in Seconds)

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

Monitor Thread Sleep Time in Fault Condition (in Seconds)

Enter 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 server to switch from the backup database to the primary database when the primary database becomes available again after a failover condition.