Editing project type options

You can modify options for Helix ALM project databases hosted in a Relational Database Management System (RDBMS), including the ability to destroy inactive projects, validating and timing out pooled connections, and reattempting connections to RDBMS servers.

1. Click Server Options.

The Edit Server Options dialog box opens.

2. Click the Project Type tab.

3. Make any changes.

Field	Description	Default value
Allow administrator to permanently destroy inactive projects	If selected, adds a Delete button to the Projects dialog box in the Helix ALM Server Admin Utility, which allows administrators to delete all database tables when deleting a inactive project from an RDBMS database. Deleting all tables can be helpful to save hard disk space or completely delete projects created by mistake.	Not selected
Validate pooled connections every X minutes	Indicates how often the server maintenance thread should validate pooled connections. The server maintains a number of connections to the database in a pool for performance reasons. The database server or a network router/firewall may interrupt connections if they are inactive for a period of time. This process also runs if a communication error is detected while a client request is processed. You may want to decrease the value if network or performance issues occur and you want to validate connections more frequently.	5 minutes
Timeout pooled connections after X minutes of activity	Indicates the number of minutes of inactivity before the server times out pooled connections. Inactive connections are removed and destroyed. New connections are created and added to the pool as they are requested. You may want to decrease the value if your RDBMS licensing limits the number of database connections or if you experience database connection issues under heavy user load.	30 minutes
Reattempt connection to RDBMS server for X minutes	Indicates how long the server should wait before attempting to connect to an RDBMS server before initializing the server database and loading projects if the initial connection is unsuccessful. There is a 20 second delay between each attempt. If you stop the server while it is connecting to an RDBMS server, it stops after the 20 second delay ends. You cannot log in to the server admin utility while the server is connecting to an RDBMS server.	2 minutes. Maximum is 10 minutes.

4. Click OK to save the changes.