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 220.127.116.11) 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 18.104.22.168
- Backend on which the SQL Queries are executed is a Power machine running IBM i.
Thanks in advance,