IBM Content Navigator, Version 2.0.3     Supports:  Content Manager, FileNet P8, OnDemand, OASIS CMIS

Increasing JDBC connection pool sizes for WebSphere Application Server

Users access IBM® Content Navigator through JDBC connections for the application server. If there are too many users or too few connections, the system slows down. Increasing the JDBC connection pool size value improves performance and creates more connections to the configuration database.

Before you begin

If errors occur in IBM Content Navigator during high-volume conditions or long duration transactions, you can increase the maximum connections for the JDBC connection pools. The benefit of increasing the JDBC connection pool size is that you create more connections for users to access IBM Content Navigator.

By using the administrative tools for the application server to monitor system performance, you can gauge when performance slows down and increase the connections.

Procedure

To increase the JDBC connection pool size:

  1. In WebSphere® Application Server, navigate to Resources > JDBC > Data Sources.
  2. Select the data source to modify.
  3. Click Connection pool properties.
  4. Change the default number of connections for the Maximum Connections setting. Change the setting from 10 to a higher number, such as 100.
  5. Click Apply. Over time, gradually adjust the maximum value to allow for more connections if necessary. You can increase the number of connections by 100. If performance begins to decrease, increase the number again by another 100 connections
Parent topic: Performance tuning for IBM Content Navigator