WebSphere Application Server & Liberty

WebSphere Application Server & Liberty

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
  • 1.  Need help

    Posted Wed May 25, 2016 11:56 AM

    Hi All,

    How can i findout application is hitting the database.

    With Regards,

    kalyan.

    kalyan.



  • 2.  RE: Need help

    Posted Thu May 26, 2016 06:31 AM

    Hi Kalyan,

      Is a good practice not to open threads, with "urgent, need, help,...." subject. The thread name need to honor to the question. Having said that....

      Take a look to the next thread.

      How to display SQL statements executed by JEE applications using minimal tracing

      http://www-01.ibm.com/support/docview.wss?uid=swg21496047

      You can use HealthCenter or PMT too to take a look to datasources.

      IBM Monitoring and Diagnostic Tools - Health Center
    http://www.ibm.com/developerworks/java/jdk/tools/healthcenter/

      WebSphere Application Server Performance Tuning Toolkit
    http://www.ibm.com/developerworks/websphere/downloads/performtuning.html

     

      If your application have traces, maybe you can enable traces at application level or talk with your DBA, at DB level you can have more information about who is connecting (filtering by IP addres, user,..).

      Hope this helps. Tell us if you need more support

    Regards