Sample reports

This sample shows the report 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
--------------------------------------------------------------------------------
F10: SQL CPU/Service Time by DBRM (1286/CICS23A)              Row 00001 of 00014
Command ===> __________________________________________________ Scroll ===> CSR 

                                 Nbr of    --CPU Time--     --Svc Time--
Name       Stmt#  SQL Function   SQL Calls  Total   Mean     Total   Mean

PFSAMPC                           1,204      3.08   0.00256   5.57   0.00462
± S00003    1466  FETCH             516      2.27   0.00441   3.86   0.00749
→ S00006    1316  SELECT            172      0.39   0.00227   1.01   0.00588
→ S00005    1347  SELECT            172      0.25   0.00150   0.40   0.00232
             > SELECT CUSACCT INTO : H FROM ACTINFO WHERE SPCRATE =
             > : H AND INDX01 = '01'

→ S00008    1443  OPEN              172      0.11   0.00064   0.21   0.00122
→ S00007    1562  CLOSE             172      0.04   0.00026   0.07   0.00045
PFSAMPB                             514      1.04   0.00203   1.70   0.00331
→ S00002     672  SELECT            342      0.69   0.00204   1.13   0.00332
→ S00004     810  UPDATE            172      0.34   0.00201   0.56   0.00331
PFSAMPA                             342      0.84   0.00246   1.74   0.00511
→ S00002     815  SELECT            342      0.84   0.00246   1.74   0.00511