All geek questions in one place

DB2 jdbc performance

When profiling in a Java application running websphere 7 and DB2, we see that most of the time we spend in the com.ibm.ws.rsadapter.jdbc package, processing connections to and from the database.

  • How can we tune jdbc performance?

  • What other strategies exist when database performance is a bottleneck?

thank

+3
source share
4 answers

You should check your web page guide to configure the connection pool.

Here is the introduction of code samples

+3
source

, , . , . LIST ACTIVE DATABASES ( DB2 ) . , ACTIVATE DATABASE yourDBname. , , .

GET MONITOR SWITCHES, , . , , , .

, - , DB2, , , , , DB2. - , SQL- UOW. , , SQL . db2evtbl . SET EVENT MONITOR STATE - , .

+2

, , , . , DB2...

, , -, .. - , , , , , , .

, , , , , .

!

+1
0

Source: https://habr.com/ru/post/1734262/

More articles:


All Articles