This sample shows the report with one Correlation ID expanded to the third level (SQL text).
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)
[ Top of Page | Previous Page | Next Page | Contents | Index ]