Sample reports

In this sample, the P0001 plan line has been expanded to the second level (SQL statement), and one of the statements has been expanded to the third level to show the SQL text.

  File  View  Navigate  Help
--------------------------------------------------------------------------------
F09: SQL WAIT Time by Plan (0611/CICS23A)                     Row 00001 of 00010
Command ===> __________________________________________________ Scroll ===> CSR 

Seqno     Plan/Pgm  Stmt#  SQL Function  Percent of Total Time * 10.00%  ±2.5%
                                           *....1....2....3....4....5....6....7...
P0001     PFPLN022                    25.49 =============
→ S00001  PFTESTD     435  FETCH       12.05 =======
→ S00003  PFTESTD     541  UPDATE       7.50 =====
→ S00004  PFTESTD     465  FETCH        3.95 ==
→ S00002  PFTESTD     455  FETCH        1.91 =
              > DECLARE RATE2 CURSOR FOR SELECT * FROM CUSTAMTS

→ S00005  PFTESTD    485  FETCH        0.06