Sample reports

This sample shows the report with the plan expanded to the second level and one of the SQL statement lines expanded to the third level to show SQL text.
  File  View  Navigate  Help
--------------------------------------------------------------------------------
F12: SQL CPU/Service Time by Plan (1300/CICS23A)              Row 00001 of 00018
Command ===> __________________________________________________ Scroll ===> CSR 

                                    Nbr of    --CPU Time--        --Svc Time--
Seqno  Plan/PGM  Stmt# SQL Function SQL Calls  Total   Mean        Total   Mean

P0001  PFSAMPA                         4,810   6.25    0.00130     10.73   0.00223
→ S00007 PFSAMPC    1466 FETCH           344   1.48    0.00432      2.35   0.00685
→ S00001 PFSAMPA     816 SELECT          342   0.88    0.00258      1.70   0.00497
              > SELECT NEXTLIM INTO : H FROM MRATE WHERE CURATE = : H

→ S00009 PFSAMPC    3054 FETCH         1,720   0.74    0.00043      1.15   0.00066
→ S00003 PFSAMPB     678 SELECT          342   0.47    0.00137      0.75   0.00221
→ S00004 PFSAMPC    1316 SELECT          172   0.42    0.00249      0.76   0.00446
→ S00010 PFSAMPB     816 UPDATE          172   0.39    0.00231      0.75   0.00441
→ S00002 PFSAMPB     408 SET HOST V      342   0.38    0.00112      0.72   0.00211
→ S00005 PFSAMPC    1347 SELECT          172   0.27    0.00161      0.48   0.00282
→ S00014 PFSAMPC    3155 SELECT          172   0.27    0.00160      0.41   0.00243
→ S00012 PFSAMPC    3179 SELECT          172   0.27    0.00158      0.47   0.00277
→ S00011 PFSAMPC    2989 SELECT          172   0.22    0.00130      0.38   0.00221
→ S00008 PFSAMPC    3046 OPEN            172   0.20    0.00121      0.29   0.00170
→ S00006 PFSAMPC    1443 OPEN            172   0.11    0.00067      0.31   0.00181
→ S00013 PFSAMPC    1562 CLOSE           172   0.04    0.00028      0.08   0.00048
→ S00015 PFSAMPC    3065 CLOSE           172   0.03    0.00021      0.05   0.00034