V03 DB2® Variance Summary
The following tag pairs are repeated multiple times in
each variance report. The first occurrence of the tag pair reports
the base measurement (Ref 01). Following Ref 01, the tag pairs are
repeated for every tagged measurement (Ref n).
- <MeasurementsAnalyzed></MeasurementsAnalyzed>
- <DB2SQLVariance></DB2SQLVariance>
- <SQLObservations></SQLObservations>
- <SQLCallsExecuted></SQLCallsExecuted>
- <SQLCallRate></SQLCallRate>
- <SQLCallsCounted></SQLCallsCounted>
- <SQLThroughput></SQLThroughput>
- <SQLServiceTime></SQLServiceTime>
- <SQLCallMaxTimet></SQLCallMaxTime>
- <SQLCallMinTime></SQLCallMinTime>
- <SQLCPUTime></SQLCPUTime>
- <SQLCallMaxCPUTime></SQLCallMaxCPUTime>
- <SQLCallMinCPUTime></SQLCallMinCPUTime>
| Field title in online report | XML element |
|---|---|
| The Following Measurements are Analyzed | <MeasurementsAnalyzed> |
| Ref | <Ref>n</Ref> |
| ReqNum | <ReqNum>n</ReqNum> |
| Job Name | <JobName>name</JobName> |
| Date | <Date>Mon-dd-yyyy</Date> |
| Time | <Time>hh:mm</Time> |
| Description | <Description>description</Description> |
| </MeasurementsAnalyzed> | |
| SQL calls sampled | <DB2SQLVariance> |
| Ref | <Ref>n</Ref> |
| Subsys | <Subsystem>name</Subsystem> |
| Version | <Version>version</Version> |
| Calls Sampled | <CallsSampled>n</CallsSampled> |
| Variance | <Variance>variance</Variance> |
| </DB2SQLVariance> | |
| SQL observations | <SQLObservations> |
| Ref | <Ref>n</Ref> |
| Count | <SQLCount>n</SQLCount> |
| Variance | <Variance>variance</Variance> |
| </SQLObservations> | |
| SQL calls executed | <SQLCallsExecuted> |
| Ref | <Ref>n</Ref> |
| Count | <SQLCount>n</SQLCount> |
| Variance | <Variance>variance</Variance> |
| </SQLCallsExecuted> | |
| Avg SQL call rate | <SQLCallRate> |
| Ref | <Ref>n</Ref> |
| Rate | <SQLRate>n per sec</SQLRate> |
| Variance | <Variance>variance</Variance> |
| </SQLCallRate> | |
| SQL calls counted | <SQLCallsCounted> |
| Ref | <Ref>n</Ref> |
| Count | <SQLCount>n</SQLCount> |
| Variance | <Variance>variance</Variance> |
| </SQLCallsCounted> | |
| SQL throughput | <SQLThroughput> |
| Ref | <Ref>n</Ref> |
| Rate | <SQLRate>n per sec</SQLRate> |
| Variance | <Variance>variance</Variance> |
| </SQLThroughput> | |
| SQL service time | <SQLServiceTime> |
| Ref | <Ref>n</Ref> |
| Time | <ServiceTime>n sec</ServiceTime> |
| Variance | <Variance>variance</Variance> |
| </SQLServiceTime> | |
| SQL call max | <SQLCallMaxTime> |
| Ref | <Ref>n</Ref> |
| Time | <ServiceTime>n sec</ServiceTime> |
| Variance | <Variance>variance</Variance> |
| </SQLCallMaxTime> | |
| SQL call min time | <SQLCallMinTime> |
| Ref | <Ref>n</Ref> |
| Time | <ServiceTime>n sec</ServiceTime> |
| Variance | <Variance>variance</Variance> |
| </SQLCallMinTime> | |
| SQL CPU time | <SQLCPUTime> |
| Ref | <Ref>n</Ref> |
| Time | <CPUTime>n sec</CPUTime> |
| Variance | <Variance>variance</Variance> |
| </SQLCPUTime> | |
| SQL call max CPU time | <SQLCallMaxCPUTime> |
| Ref | <Ref>n</Ref> > |
| Time | <CPUTime>n sec</CPUTime> |
| Variance | <Variance>variance</Variance> |
| </SQLCallMaxCPUTime> | |
| SQL call min CPU time | <SQLCallMinCPUTime> |
| Ref | <Ref>n</Ref> |
| Time | <CPUTime>n sec</CPUTime> |
| Variance | <Variance>variance</Variance> |
| </SQLCallMinCPUTime> |