The following sample report shows the variances between a base CICS® 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
[ Top of Page | Previous Page | Next Page | Contents | Index ]