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> |
[ Top of Page | Previous Page | Next Page | Contents | Index ]