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

F12 SQL CPU/Service Time by Plan

Field title in online report XML element
<SQLCPUTimeByPlan>
Seqno <SequenceNumber>seqno</SequenceNumber>
Plan/Pgm <PlanName>name</PlanName>
Nbr of SQL Calls <NumberOfCalls>n</NumberOfCalls>
--CPU Time -- Total <TotalServiceTime>n</TotalServiceTime>
--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>
</SQLCPUTimeByPlanDetail>
Seqno <SequenceNumber>seqno</SequenceNumber>
Plan/Pgm <ProgramName>name</ProgramName>
Stmt# <StatementNumber>n</StatementNumber>
SQL Function <SQLFunction>function</SQLFunction>
Nbr of SQL Calls <NumberOfCalls>n</NumberOfCalls>
--CPU Time -- Total <TotalServiceTime>n</TotalServiceTime>
--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>
</SQLCPUTimeByPlanDetail>
</SQLCPUTimeByPlan>



Rate this page

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