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