Question

What are the preferred JDBC connection pool setting in web sphere

Hi,

What are the preferred JDBC connection pool setting in web sphere

What number need to maintain in Minimum connection and Maximum connection

Comments

Keep up to date on this post and subscribe to comments

August 21, 2019 - 6:17pm

A good starting point is 30 for minimum and 100 for the maximum. You can tune according to your load. Use Tivoli (coming with Websphere) to monitor the usage of the connection pool.

August 26, 2019 - 10:26am
Response to KevinZheng_GCS

Thank you Kevin for the details.

If the connection pool minimum value is zero, does it impact the application performance?

Does system take more time for first query execution?