Configuring Connection Pool Settings in the P6 Progress Reporter Administrator

Contents

Use the Connection Pool tab to modify settings for multiple database connections.

To set your connection pool settings:

1. Open the P6 Progress Reporter Administrator.
2. Select the Connection Pool tab.
3. In the Initial Connection Pool Size field, enter the number of database connections allowed for the P6 Progress Reporter server.

   The default is 10.

   Enter anything from 0-1000.

4. In the Maximum active database connections field, enter the maximum number of database connections that can run at the same time.

   The default is 150.

   Enter anything from -1-1000.

5. In the Maximum idle database connections field, enter the maximum number of database connections that can be inactive.

   The default is -1.

   Enter anything from -1-1000.

6. In the Maximum idle database connections field, enter the minimum number of database connections that can be inactive.

   The default is 10.

   Enter anything from 0-1000.

Tips

• Changes to Connection Pool tab settings always require you reboot the application server instance.
• A value of -1 for the maximum settings will make the number of connections unlimited.