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