|
<WASDB2Activity> |
Seqno |
<SequenceNumber>n</SequenceNumber> |
WAS Request |
<WASRequest>name</WASRequest> |
Nbr of SQL Calls |
<NumberofCalls>n</NumberofCalls> |
--CPU Time – Total |
<TotalCPUTime>n</TotalCPUTime> |
--CPU Time – Mean |
<MeanCPUTime>n</MeanCPUTime> |
--CPU Time – Mean |
<PctCPUTime>n</PctCPUTime> |
--Svc Time – Total |
<TotalServiceTime>n</TotalServiceTime> |
--Svc Time – Mean |
<MeanServiceTime>n</MeanServiceTime> |
--Svc Time – Mean |
<PctServiceTime>n</PctServiceTime> |
|
</WASDB2Activity> |
|
<SQLCPUTimeByStatement> |
Seqno |
<SequenceNumber>n</SequenceNumber> |
DB2® Call |
<ProgramName>name</ProgramName> |
|
<StatementNumber>n</StatementNumber> |
|
<SQLFunction>name</SQLFunction> |
Nbr of SQL Calls |
<NumberofCalls>n</NumberofCalls> |
--CPU Time – Total |
<TotalCPUTime>n</TotalCPUTime> |
--CPU Time – Mean |
<MeanCPUTime>n</MeanCPUTime> |
--CPU Time – Mean |
<PctCPUTime>n</PctCPUTime> |
--Svc Time – Total |
<TotalServiceTime>n</TotalServiceTime> |
--Svc Time – Mean |
<MeanServiceTime>n</MeanServiceTime> |
--Svc Time – Mean |
<PctServiceTime>n</PctServiceTime> |
|
</SQLCPUTimeByStatement> |
|
<SQLTextLines> |
|
<SQLTEXT>text</SQLTEXT> |
|
<PrepareInfo> |
|
<PrepareStatementNumber>n</PrepareStatementNumber> |
|
<PrepareSequenceNumber>n</PrepareSequenceNumber> |
|
</PrepareInfo> |
|
</SQLTextLines> |