Sample reports

  File  View  Navigate  Help
--------------------------------------------------------------------------------
F19: DB2 SQL CPU/Svc Time by EndUsr (1641/DB2ADIST)           Row 00001 of 00336
Command ===> __________________________________________________ Scroll ===> CSR

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

USR01                               121     0.67   0.00555       16.74   0.13837
± D00016       0  EXECUTE IMME         3     0.11   0.03885       0.13    0.04345
               >  EXPLAIN PLAN SET QUERYNO=1 FOR SELECT
               > COALESCE(FIELD_ONE_KEY, DEP2_COL1_KEY) AS COL1_KEY
               > ,COALESCE(DEP2_COL2_KEY, DEP3_COL2_KEY) AS COL2_KEY
               > ,DEP3_COL3_KEY ,DEP3_COL4 ,DEP3_COL5 ,DEP2_COL3
               > ,DEP2_COL4 ,FIELD_TWO ,FIELD_THREE ,FIELD_FOUR
               > ,FIELD_FIVE ,FIELD_SIX ,FIELD_SEVEN
               > ,CHAR(FIELD_EIGHT,ISO) ,CHAR(FIELD_NINE,ISO)
               > ,FIELD_TEN ,TIMEZONE () FROM MAIN FULL OUTER JOIN DEP2
               > ON DEP2_COL1_KEY = FIELD_ONE_KEY LEFT JOIN DEP3 ON
               > DEP3_COL1_KEY = DEP2_COL1_KEY AND DEP3_COL2_KEY =
               > DEP2_COL2_KEY ORDER BY COL1_KEY ,COL2_KEY
               > ,DEP3_COL3_KEY

→ D00020       0  FETCH                12     0.08    0.00744      0.09    0.00763
               >  SELECT * FROM PLAN_TABLE ORDER BY QUERYNO, QBLOCKNO,
               >  PLANNO
               >  (PREPARE of SQL was done at Stmt# 0 Seqno D00017)

→ D00019       0  OPEN                 3     0.08    0.02768      0.08    0.02891
               >  SELECT * FROM PLAN_TABLE ORDER BY QUERYNO, QBLOCKNO,
               >  PLANNO
               >  (PREPARE of SQL was done at Stmt# 0 Seqno D00017)

→ D00034       0  FETCH                3     0.05    0.01741      0.05    0.01809
               >  ( SELECT T1.FIELD_ONE_KEY AS
               > UNION_COLUMN_01 ,T1.FIELD_TWO AS
               > UNION_COLUMN_02 FROM AIF04.MAIN T1 WHERE NOT EXISTS
               > (SELECT * FROM AIF04.DEP1 T2 WHERE T1.FIELD_ONE_KEY =
               > T2.DEP1_COL1_KEY1 ) UNION SELECT T3.FIELD_ONE_KEY
               > AS UNION_COLUMN_01 ,T3.FIELD_TWO
               > AS UNION_COLUMN_02 FROM AIF04.MAIN T3 WHERE NOT EXISTS
               > (SELECT * FROM AIF04.DEP2 T4 WHERE T3.FIELD_ONE_KEY =
               > T4.DEP2_COL1_KEY ) ) UNION ALL ( SELECT