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
[ Top of Page | Previous Page | Next Page | Contents | Index ]