Sample reports

A sample report is shown here with a plan expanded to the second level (statement) and a statement expanded to show the SQL text.

  File  View  Navigate  Help
--------------------------------------------------------------------------------
F05:  SQL Activity by Plan (1336/CICS23A)                     Row 00001 of 00017
Command ===> __________________________________________________ Scroll ===> CSR 

Seqno     Plan/Pgm  Stmt# SQL Function   Percent of Time * 10.00%  ±1.1%
                                           *....1....2....3....4....5....6.....7.
P0001     PFSAMPA                      20.60 ==========
→ S00003  PFSAMPC    1466 FETCH         5.79 ===
→ S00001  PFSAMPA     816 SELECT        3.10 ==
              > SELECT NEXTLIM INTO : H FROM MRATE WHERE CURATE = : H

→ S00005  PFSAMPC    3054 FETCH         2.29 =
→ S00012  PFSAMPB     678 SELECT        1.94 =
→ S00011  PFSAMPC    1316 SELECT        1.47 =
→ S00010  PFSAMPB     816 UPDATE        1.40 =
→ S00007  PFSAMPC    3179 SELECT        1.09 =
→ S00002  PFSAMPC    1347 SELECT        0.89
→ S00009  PFSAMPC    3155 SELECT        0.79
→ S00008  PFSAMPC    2989 SELECT        0.68
→ S00013  PFSAMPC    1433 OPEN          0.60
→ S00004  PFSAMPC    3046 OPEN          0.30
→ S00014  PFSAMPC    1562 CLOSE         0.14
→ S00006  PFSAMPC    3065 CLOSE         0.12