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

F01 DB2 Measurement profile

Field title in online report XML element
Most Active DB2 Plans <MostActiveDB2Plans>
Samples <Samples>n</Samples>
<Percent>n%</Percent>
Reports <Reports>F05</Reports>
<Plans>
<PlanName>name</Planame>
<CPUActive>n</CPUActive>
<CPUActivePercent>n%</CPUActivePercent>
</Plans>
</MostActiveDB2Plans>
Most Active Package/DBRM <MostActiveDBRMs>
Samples <Samples>n</Samples>
<Percent>n%</Percent>
Reports <Reports>F03</Reports>
<DBRMs>
<DBRM>name</DBRM>
<CPUActive>n</CPUActive>
<CPUActivePercent>n%</CPUActivePercent>
</DBRMs>
</MostActiveDBRMs>
Most Active SQL Statements <MostActiveSQL>
Samples <Samples>n</Samples>
<Percent>n%</Percent>
Reports <Reports>F04</Reports>
<SQLStatement>
<ProgramOffsetVerb>name:offset verb</ProgramOffsetVerb>
<CPUActive>n</CPUActive>
<CPUActivePercent>n%</CPUActivePercent>
</SQLStatement>
</MostActiveSQL>
Most CPU consumptive SQL <MostCPUConsumptiveSQL>
Total SQL CPU time <CPUTime>n</CPUTime>
<Percent>n%</Percent>
Reports <Reports>F10 F11 F12</Reports>
<SQLStatement>
<ProgramOffsetVerb>name:offset verb</ProgramOffsetVerb>
<CPUActive>n%</CPUActive>
<CPUActivePercent>n%</CPUActivePercent>
</SQLStatement>
</MostCPUConsumptiveSQL>
Most Frequent SQL Statements <MostFrequentSQL>
Total SQL call count <Samples>n</Samples>
<Percent>n%</Percent>
<SQLStatement>
<ProgramOffsetVerb>name:offset verb</ProgramOffsetVerb>
<CPUActive>n%</CPUActive>
<CPUActivePercent>n%</CPUActivePercent>
</SQLStatement>
</MostFrequentSQL>
Single SQL Call Service Time <SingleSQLCallServiceTime>
Total SQL service count <Samples>n</Samples>
<Percent>n%</Percent>
<SQLStatement>
<ProgramOffsetVerb>name:offset verb</ProgramOffsetVerb>
<CPUActive>n%</CPUActive>
<CPUActivePercent>n%</CPUActivePercent>
</SQLStatement>
</SingleSQLCallServiceTime>
Db2 Measurement Statistics <DB2MeasurementStatistics>
DB2 subsystem name <SubsystemName>name</SubsystemName>
DB2 version <Version>version</Version>
SQL calls sampled <CallsSampled>n</CallsSampled>
SQL observations <SQLObservations>n</SQLObservations>
SQL calls executed <CallsExecuted>n</CallsExecuted>
Avg SQL call rate <CallRate>n per sec</CallRate>
SQL calls counted <CallsCounted>n</CallsCounted>
SQL throughput <SQLThroughput>n per sec</SQLThroughput>
SQL service time <ServiceTime>n sec</ServiceTime>
SQL CPU time <CPUTime>n sec</CPUTime>
CQL call max time <CallMaxTime>n sec</CallMaxTime>
SQL call max CPU <CallMaxCPU>n sec</CallMaxCPU>
SQL call min time <CallMinTime>n sec</CallMinTime>
SQL call min CPU <CallMinCPU>n sec</CallMinCPU>
</DB2MeasurementStatistics>



Rate this page

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