This sample shows the report with one Workstation id expanded to the third level (SQL text)
File View Navigate Help -------------------------------------------------------------------------------- F18: DB2 SQL CPU/Svc Time by Wkstn (1641/DB2ADIST) Row 00001 of 00337 Command ===> __________________________________________________ Scroll ===> CSR Nbr of --CPU Time-- --Svc Time-- Wkstn Stmt# SQL Function SQL Calls Total Mean Total Mean D12A3H26 105 0.57 0.00548 0.61 0.00586 ± 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
[ Top of Page | Previous Page | Next Page | Contents | Index ]