| 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> |