Sample reports

  File  View  Navigate  Help
--------------------------------------------------------------------------------
F17: DB2 SQL CPU/Svc Time by Corrid (1641/DB2ADIST)           Row 00001 of 00314
Command ===> __________________________________________________ Scroll ===> PAGE

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

db2bp.exe                             160     0.63   0.00394      25.92   0.16200
± D00026        0  EXECUTE IMME         4     0.16   0.04137      0.20    0.05004
               >  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
± D00007        0  FETCH                4     0.07    0.01895      0.07    0.01983
               >  ( 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
               >  T2.FIELD_ONE_KEY AS UNION_COLUMN_01
               >  ,T2.FIELD_TWO AS UNION_COLUMN_02 FROM
               >  AIF04.MAIN T2 WHERE NOT EXISTS (SELECT * FROM
               >  AIF04.DEP1 T1 WHERE T2.FIELD_ONE_KEY =
               >  T1.DEP1_COL1_KEY1 ) UNION SELECT T4.FIELD_ONE_KEY
               >  AS UNION_COLUMN_01 ,T4.FIELD_TWO
               >  AS UNION_COLUMN_02 FROM AIF04.MAIN T4 WHERE NOT EXISTS
               >  (SELECT * FROM AIF04.DEP2 T3 WHERE T4.FIELD_ONE_KEY =
               >  T3.DEP2_COL1_KEY ) )
               >  (PREPARE of SQL was done at Stmt# 0 Seqno D0005)