Sample reports

A sample report is shown here:

  File  View  Navigate  Help
--------------------------------------------------------------------------------
F04: SQL Activity by Statement (0659/CICS23A)                 Row 00001 of 00020
Command ===> __________________________________________________ Scroll ===> CSR 

Seqno   Program  Stmt#  SQL Function Percent of Total Time * 10.00%  ±1.1%
                                        *....1....2....3....4....5....6....7...
S00012  PFSAMPC  01466  FETCH        9.13 =====
S00013  PFSAMPB  00816  UPDATE       3.28 ==
S00001  PFSAMPA  00816  SELECT       2.00 =
S00008  PFSAMPC  01316  SELECT       1.82 =
S00017  PFSAMPC  03054  FETCH        1.81 =
S00004  PFSAMPB  00678  SELECT       1.67 =
S00010  PFSAMPC  01347  SELECT       1.48 =
S00002  PFSAMPB  00408  SET HOST VA  1.26 =
S00011  PFSAMPC  01433  OPEN         0.80
S00018  PFSAMPC  03155  SELECT       0.66
S00015  PFSAMPC  02989  SELECT       0.48
S00019  PFSAMPC  03179  SELECT       0.43
S00014  PFSAMPC  01562  CLOSE        0.26
S00016  PFSAMPC  03046  OPEN         0.25
S00020  PFSAMPC  03065  CLOSE        0.05
S00007  PFSAMPB  01385  SELECT       0.03
S00005  PFSAMPB  00947  SELECT       0.02
S00003  PFSAMPB  00408  SET HOST VA  0.01
S00006  PFSAMPB  01163  SELECT       0.01
S00009  PFSAMPC  01316  SELECT       0.01

Each line can be expanded to display the SQL statement by entering the “+” line command on the Sequence Number. For example, “+” was entered on the third line in this report to display the SQL.

  File  View  Navigate  Help
--------------------------------------------------------------------------------
F04: SQL Activity by Statement (0659/CICS23A)                 Row 00001 of 00022
Command ===> __________________________________________________ Scroll ===> CSR 

Seqno   Program  Stmt#  SQL Function Percent of Total Time * 10.00%  ±1.1%
                                        *....1....2....3....4....5....6....7...
S00012  PFSAMPC  01466  FETCH        9.13 =====
S00013  PFSAMPB  00816  UPDATE       3.28 ==
S00001  PFSAMPA  00816  SELECT       2.00 =
              > SELECT * INTO : H FROM DEPTA WHERE XRATE = : H

S00008  PFSAMPC  01316  SELECT       1.82 =
S00017  PFSAMPC  03054  FETCH        1.81 =
S00004  PFSAMPB  00678  SELECT       1.67 =
S00010  PFSAMPC  01347  SELECT       1.48 =
S00002  PFSAMPB  00408  SET HOST VA  1.26 =
S00011  PFSAMPC  01433  OPEN         0.80
S00018  PFSAMPC  03155  SELECT       0.66
S00015  PFSAMPC  02989  SELECT       0.48
S00019  PFSAMPC  03179  SELECT       0.43
S00014  PFSAMPC  01562  CLOSE        0.26
S00016  PFSAMPC  03046  OPEN         0.25
S00020  PFSAMPC  03065  CLOSE        0.05
S00007  PFSAMPB  01385  SELECT       0.03