Sample reports
The following sample report shows the variances between a base DB2® measurement and 2 tagged DB2 measurements.
V03: DB2 Measurement Variance Summary (5592/CICS32A) Row 00003 of 00105
The Following Measurements are Analyzed
Ref ReqNum Job Name Date Time Description
01 5592 CICS32A Aug-09-2010 12:36 Variance 1 (Base)
02 5593 CICS32A Aug-09-2010 12:39 Variance 2
03 5594 CICS32A Aug-09-2010 12:41 Variance 3
________________________________________________________________________________
SQL calls sampled
-----DB2----- Calls
Ref Subsys Version Sampled Variance
01 DB9G 9.1.0 1,205
02 DB9G 9.1.0 635 - 47 % <<
03 DB9G 9.1.0 630 - 47 % <<
________________________________________________________________________________
SQL observations
Ref Count Variance
01 1,338
02 726 - 45 % <<
03 721 - 46 % <<
________________________________________________________________________________
SQL calls executed
Ref Count Variance
01 5,871
02 2,997 - 48 % <<
03 2,997 - 48 % <<
________________________________________________________________________________
Avg SQL call rate
Ref Rate Variance
01 195.70 per sec
02 100.23 per sec - 48 % <<
03 100.23 per sec - 48 % << V03: DB2 Measurement Variance Summary (5592/CICS32A) Row 00035 of 00105
________________________________________________________________________________
Avg SQL call rate
Ref Rate Variance
01 195.70 per sec
02 100.23 per sec - 48 % <<
03 100.23 per sec - 48 % <<
________________________________________________________________________________
SQL calls counted
Ref Count Variance
01 2,937
02 1,500 - 48 % <<
03 1,500 - 48 % <<
________________________________________________________________________________
SQL throughput
Ref Rate Variance
01 1505.38 per sec
02 1427.14 per sec - 5 %
03 1427.14 per sec - 5 %
________________________________________________________________________________
SQL service time
Ref Time Variance
01 3.9691 sec
02 2.2327 sec - 43 % <<
03 2.2025 sec - 44 % <<
________________________________________________________________________________
SQL call max time
Ref Time Variance
01 0.0174 sec
02 0.0313 sec + 79 % >>>>
03 0.0157 sec - 9 % V03: DB2 Measurement Variance Summary (5592/CICS32A) Row 00067 of 00105
________________________________________________________________________________
SQL call max time
Ref Time Variance
01 0.0174 sec
02 0.0313 sec + 79 % >>>>
03 0.0157 sec - 9 %
________________________________________________________________________________
SQL call min time
Ref Time Variance
01 0.0003 sec
02 0.0003 sec
03 0.0003 sec
________________________________________________________________________________
SQL CPU time
Ref Time Variance
01 1.9055 sec
02 0.9905 sec - 48 % <<
03 1.0115 sec - 46 % <<
________________________________________________________________________________
SQL call max CPU
Ref Time Variance
01 0.0033 sec
02 0.0032 sec - 3 %
03 0.0033 sec
________________________________________________________________________________
SQL call min CPU
Ref Time Variance
01 0.0002 sec
02 0.0003 sec + 50 % >>>
03 0.0002 sec