A sample report is shown here, it is a scrollable report, and is shown here split into two screen images.
File View Navigate Help -------------------------------------------------------------------------------- F01: DB2 Measurement Profile (1354/CICS23A) Row 00001 of 00060 Command ===> __________________________________________________ Scroll ===> CSR Most Active DB2 Plans ---------------------------------------- Reports: Samples 10,000 100.0% ' ' ' ' ' ' ' ' ' ' ' F07 PFSAMPA 1,710 17.1% *** Most Active Package/DBRMs ------------------------------------ Reports: Samples 10,000 100.0% ' ' ' ' ' ' ' ' ' ' ' F03 PFSAMPC 1,173 11.7% ** PFSAMPB 302 3.0% * PFSAMPA 235 2.3% * Most Active SQL Statements ----------------------------------- Reports: Samples 10,000 100.0% ' ' ' ' ' ' ' ' ' ' ' F04 PFSAMPC:01466 FETCH 452 4.5% * PFSAMPA:00816 SELECT 273 2.7% * PFSAMPC:03054 FETCH 215 2.1% * PFSAMPB:00678 SELECT 195 1.9% * PFSAMPB:00816 UPDATE 148 1.4% * Most CPU consumptive SQL ------------------------------------- Reports: Total SQL CPU time 6.24 100.0% ' ' ' ' ' ' ' ' ' ' ' F10 F11 PFSAMPC:01466 FETCH 1.62 25.9% ***** F12 PFSAMPA:00816 SELECT 0.88 14.2% ** PFSAMPC:03054 FETCH 0.75 12.1% ** PFSAMPB:00678 SELECT 0.68 11.0% ** PFSAMPC:01316 SELECT 0.44 7.1% *
File View Navigate Help -------------------------------------------------------------------------------- F01: DB2 Measurement Profile (1354/CICS23A) Row 00031 of 00061 Command ===> __________________________________________________ Scroll ===> CSR Most Frequent SQL Statements ----------------------------------- Reports: Total SQL calls counted 4,492 100.0% ' ' ' ' ' ' ' ' ' ' ' ' PFSAMPC:03054 FETCH 1,730 38.5% ******* PFSAMPC:01466 FETCH 346 7.7% * PFSAMPA:00816 SELECT 343 7.6% * PFSAMPB:00678 SELECT 343 7.6% * PFSAMPC:01443 OPEN 173 3.8% * Most CPU consumptive SQL --------------------------------------- Reports: Total SQL service time 11.03 100.0% ' ' ' ' ' ' ' ' ' ' ' ' PFSAMPB:00678 SELECT 0.16 25.9% ***** PFSAMPC:01466 FETCH 0.09 14.2% ** PFSAMPA:00816 SELECT 0.03 12.1% ** PFSAMPC:01347 SELECT 0.03 11.0% ** PFSAMPC:01316 SELECT 0.01 7.1% * DB2 measurements statistics-------------------------------------------------- | DB2 subsystem name DSN1 | DB2 version 7.1.0 | |----------------------------------------------------------------------------| | SQL calls sampled 1,521 | SQL observations 1,890 | | SQL calls executed 5,517 | Avg SQL call rate 91.95 per sec | | SQL calls counted 4,492 | SQL throughput 510.83 per sec | |----------------------------------------------------------------------------| | SQL service time 11.0362 sec | SQL CPU time 6.2409 sec | | SQL call max time 0.1678 sec | SQL call max CPU 0.0598 sec | | SQL call min time 0.0001 sec | SQL call min CPU 0.0001 sec | *----------------------------------------------------------------------------*
[ Top of Page | Previous Page | Next Page | Contents | Index ]