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