Sample reports
This sample shows the report with one Enclave token expanded to the third level (SQL text).
File View Navigate Help
--------------------------------------------------------------------------------
F16: DB2 SQL CPU/Svc Time by Enclave (1641/DB2ADIST) Row 00001 of 01410
Command ===> __________________________________________________ Scroll ===> PAGE
Nbr of --CPU Time-- --Svc Time--
Token Stmt# SQL Function SQL Calls Total Mean Total Mean
00000020-0000017E 1 0.04 0.04177 0.05 0.05652
± D00026 0 EXECUTE IMME 1 0.04 0.04177 0.05 0.05652
> 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
00000024-00000198 1 0.04 0.04154 0.04 0.04668
→ D00026 0 EXECUTE IMME 1 0.04 0.04154 0.04 0.04668
> 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
00000020-000001A8 1 0.04 0.04167 0.04 0.04925
→ D00026 0 EXECUTE IMME 1 0.04 0.04167 0.04 0.04925
> 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