Java Database Connectivity connection pools

WAS connection pooling can improve the response time of any application that require connections.

Requests over the Web to a data resource are done through WAS data sources, for example the FNP8 Object Store database or ICN database. These databases can be accessed through WAS data sources.

Typically ECM applications request large amounts of data and the total overhead can become very high. However, with appropriate connection pool sizes, ECM applications can improve performance and achieve better response times.

It is important to ensure that the database can have enough maximum connections to match the maximum number of JDBC connections.

The Java™ database connectivity (JDBC) connection pools for the FNP8 Object Store and the ICN databases are increased.

In this case study:

The value of Maximum connections was increased from 10 to 1000 connections.

WAS Administration console path: Resources > JDBC > Data sources > data_source_name > Connection pool properties.

For further information about WAS connection pooling, proceed to this IBM® Knowledge Center URL:

https://www.ibm.com/docs/en/was-nd/8.5.5

Then select Tuning performance.