I am trying to gather metrics for analyzing DB2 Query performance and I am hitting unforeseen roadblocks.
When using the EXPLAIN parameter as part of my DB2 QUERY [Example below], I expected the DSN_STATEMENT_TABLE and the PLAN_TABLE to both populate rows with the appropriate values.
The PLAN_TABLE created new entries for each execution of my SQL. Wonderful!
The DSN_STATEMENT_TABLE did not. No Joy there..
Code:
EXPLAIN ALL SET QUERYNO=444 FOR
Here is the statement I'm executing to gather statistics. it runs fine yet returns 0 Rows.
Code:
SELECT
DST.EXPLAIN_TIME,
DST.STMT_TYPE,
DST.PROCMS,
DST.PROCSU,
DST.TOTAL_COST,
DUT.STMT_ID,
DUT.STATEMENT
FROM SYSIBM.DSN_STATEMNT_TABLE DST
JOIN SYSIBM.SYSPACKSTMT DUT
ON DST.PER_STMT_ID = DUT.STMT_ID
WITH UR
;
This is obviously a DB2 setup issue and since we have no DB2 admin on staff anymore (Upper Management let the wrong people go!), it's left to the developers to fill the void.
Would anyone be able to point me in any direction that would be beneficial?
