Sample reports
This sample shows the report with one of the lines expanded to the second level to show SQL text.
File View Navigate Help
--------------------------------------------------------------------------------
F11: SQL CPU/Service Time by Statement (1300/CICS23A) Row 00001 of 00017
Command ===> __________________________________________________ Scroll ===> CSR
Nbr of --CPU Time-- --Svc Time--
Seqno Name Stmt# SQL Function SQL Calls Total Mean Total Mean
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 VAR 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