Application Performance Analyzer for z/OS, Version 11.1, User's Guide

F16 DB2 SQL CPU/Svc Time by Enclave

Field title in online report XML element
<SQLTimeByEnclave>
Token <Token>token</Token>
Nbr of SQL Calls <NumberOfCalls>n</NumberOfCalls>
--CPU Time -- Total <TotalCPUTime>n</TotalCPUTime>
--CPU Time-- Mean <MeanCPUTime>n</MeanCPUTime>
--CPU Time-- Pct <PctCPUTime>n</PctCPUTime>
--Svc Time-- Total <TotalServiceTime>n</TotalServiceTime>
--Svc Time-- Mean <MeanServiceTime>n</MeanServiceTime>
--Svc Time-- Pct <PctServiceTime>n</PctServiceTime>
<GetPagesIdx>n</GetPagesIdx>
<GetPages>n</GetPages>
<SyncReadIO>n</SyncReadIO>
<PrefetchReq>n</PrefetchReq>
<SyncWriteIO>n</SyncWriteIO>
<SQLTimeByStatement>
Token <SequenceNumber>seqno</SequenceNumber>
Stmt# <StatementNumber>n</StatementNumber>
SQL Function <SQLFunction>function</SQLFunction>
Nbr of SQL Calls <NumberOfCalls>n</NumberOfCalls>
--CPU Time -- Total <TotalCPUTime>n</TotalCPUTime>
--CPU Time-- Mean <MeanCPUTime>n</MeanCPUTime>
--CPU Time-- Pct <PctCPUTime>n</PctCPUTime>
--Svc Time-- Total <TotalServiceTime>n</TotalServiceTime>
--Svc Time-- Mean <MeanServiceTime>n</MeanServiceTime>
--Svc Time-- Pct <PctServiceTime>n</PctServiceTime>
<SQLTextLines>
<SQLTEXT>sqltext</SQLTEXT>
<PrepareInfo>
<PrepareStatementNumber>n</PrepareStatementNumber>
<PrepareSequenceNumber>seqno</PrepareSequenceNumber>
</PrepareInfo>
</SQLTextLines>
</SQLTimeByStatement>
</SQLTimeByEnclave>



Rate this page

[ Top of Page | Previous Page | Next Page | Contents | Index ]