DB2 jdbc performance

Question

doing profiling on an java application running websphere 7 and DB2 we can see that we spend most of our time in the com.ibm.ws.rsadapter.jdbc package handling connections to and from the database.

1. How can we tune our jdbc performance?

2. What other strategies exist when database performance is a bottleneck?

Thanks

Answer 1

You should check your websphere manual for how you configure a connection pool.

Update 2021

Here is an introduction inculding code samples

Update 2021