Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 John Paul Raja Christu Raja (JohnPaulRaja,C)
Maantic Inc
Consultant
Maantic Inc
US
JohnPaulRaja,C Member since 2011 302 posts
Maantic Inc
Posted: Aug 21, 2019
Last activity: Aug 26, 2019
Posted: 21 Aug 2019 11:57 EDT
Last activity: 26 Aug 2019 10:26 EDT
Closed

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

To see attachments, please log in.
System Administration
Data Integration

Posted: 5 years ago
Posted: 21 Aug 2019 18:17 EDT
Kevin Zheng (KevinZheng_GCS)
PEGA
Director, Technical Support
Pegasystems Inc.
US

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.

To see attachments, please log in.
Posted: 5 years ago
Posted: 26 Aug 2019 10:26 EDT
John Paul Raja Christu Raja (JohnPaulRaja,C)
Maantic Inc
Consultant
Maantic Inc
US

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?

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice