IC5Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Topic
  • 2 replies
  • Latest Post - ‏2013-07-22T15:42:53Z by bpaskin
Ortwin
Ortwin
2 Posts

Pinned topic A lot of PreparedStatement.executeQuery() entries in SystemOut.log

‏2013-07-16T10:23:06Z |

Hello,

 

Since some weeks the WAS running our application sometimes stalls. When this happens we see a lot (Gigabytes) of the following entries in the SystemOut.log:

[7/11/13 11:22:14:171 CEST] 0000014a PmiRmArmWrapp I   PMRM0003I:  parent:ver=1,ip=10.20.30.40,time=1373511924541,pid=3562,reqid=889694,event=1 - current:ver=1,ip=10.20.30.40,time=1373511924541,pid=3562,reqid=3383543,event=1 type=JDBC detail=java.sql.PreparedStatement.executeQuery() elapsed=1

I'm not sure where these entries come from. They can come from webservices of our application. They also can come from BIRT (reporting tool).

I'm also not sure what they mean. It appears to be the execution of an SQL Query, but why does it only take 1 millisecond (elapsed=1) ? And why are there so many? Does the execution fail and is it retried? There is a new entry about every millisecond.

 

Some additional information:

  • The webservices of our application are RESTful services generated by EGL (RBD 8.0.1.2) and they do in fact use prepared statements to execute SQL.
  • BIRT version 2.3.2 is used
  • The services aswel as BIRT run on WAS 7.0.0.23
  • Backend on which the SQL Queries are executed is a Power machine running IBM i.

 

Thanks in advance,

Ortwin

  • Ortwin
    Ortwin
    2 Posts

    Re: A lot of PreparedStatement.executeQuery() entries in SystemOut.log

    ‏2013-07-22T08:41:32Z  

    These entries in SystemOut.log are due to enabling Websphere Perfomance Monitoring.

     

    However, is it obvious that these are entries generated as a result of the Performance Monitoring (writing performance data to a database)? So being normal behaviour of the performance product?

    Or can these entries still come from our application (that would be alarming)?

     

    Ortwin

  • bpaskin
    bpaskin
    3903 Posts

    Re: A lot of PreparedStatement.executeQuery() entries in SystemOut.log

    ‏2013-07-22T15:42:53Z  
    • Ortwin
    • ‏2013-07-22T08:41:32Z

    These entries in SystemOut.log are due to enabling Websphere Perfomance Monitoring.

     

    However, is it obvious that these are entries generated as a result of the Performance Monitoring (writing performance data to a database)? So being normal behaviour of the performance product?

    Or can these entries still come from our application (that would be alarming)?

     

    Ortwin

    Hi,

    WAS does not write to a DB even when PMI is enabled.  I would do a thread dump when the problem occurs to see what is going on with the threads.

    Regards,

    Brian