Share this page

# 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.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: