Hi All,

we are facing high connection poll utilization issue consistently on every wednesday. WAS7.0 is using in our environment. 

we have already increased CPU and maximum DB connections count once.
 
but still problem is not resolved. when users are generating reports in backend through application, high cpu utilization and connection pool issue is occuring.

Also, when we checked "nmon" data free memory is very low about 1.6 % for that particular server.

we have doubt on application build also (coding level quality).
Please let us know how to check memory leak and connection leak?

ALso, please help us whether any script is available to find out the connection leakages ?

Hi Pawan,

Kindly do share with us the FP level for WAS 7.

Do check in systemout.log & systemerr.log any DB related exceptions.

Thank You,

Hi PawanKalyan

  As gbpraba says share your FP level for WAS 7 please.
 
  I suggest to enable JDBC traces

  Using Connection information in WebSphere trace files to troubleshoot J2CA0045E and J2CA0020E or connection wait time-out problems
  www-01.ibm.com/support/docview.wss?uid=s...
 
  You can follow the technote but I suggest to analyze traces with
 
  Database Connection Pool Analyzer for IBM WebSphere Application ServerContent
  www.ibm.com/developerworks/community/gro...
 
  You can get the connections count using wsadmin and create a custom script to know if its filling
 
  About memory leak
 
  Enable verbose garbage collection in WAS and then analyze with
 
  IBM Pattern Modeling and Analysis Tool for Java Garbage Collector -> you can adjust heap size
 
  www.ibm.com/developerworks/community/gro...
   
  IBM Monitoring and Diagnostic Tools for Java - Garbage Collection and Memory Visualizer Version 2.7 -> you can see if you have a memory leak

  www.ibm.com/developerworks/java/jdk/tool...

  Hope this helps. tell us if you need more support

regards