Database Connection Parameters

Database connection parameters relate to the management of the database connection pool that the PPM Server maintains. After the PPM Server starts, one database connection is established. Increased usage spawns additional database connections.

The database connection parameters, which are all defined in the server.conf file, are as follows:

• DB_LOGIN_TIMEOUT determines the amount of time that the PPM Server is to continue to try to log on to the database (acquire the JDBC connections that make up the connection pool) before reporting that the database is unavailable.

• MAX_DB_CONNECTION_IDLE_TIME determines the amount of time (in minutes) that an unused database connection is held open before it is closed and removed from the pool.

• MAX_DB_CONNECTION_LIFE_TIME determines the duration (in minutes) that a database session is held open before it is closed and removed from the pool. Some Oracle cleanup operations that should be run periodically occur only at the end of database sessions. Do not keep database sessions open for the life of the PPM Server.

• MAX_DB_CONNECTIONS determines the maximum size of the database connection pool that the PPM Server creates.