TOP_DYNAMIC_SQL!!!

Whoever defined this view should be get fired! It is an insult to db2 users/community for playing such cheap trick!

 

CREATE VIEW SYSIBMADM.TOP_DYNAMIC_SQL  ( SNAPSHOT_TIMESTAMP, NUM_EXECUTIONS, AVERAGE_EXECUTION_TIME_S, STMT_SORTS, SORTS_PER_EXECUTION, STMT_TEXT, DBPARTITIONNUM) AS SELECT  SNAPSHOT_TIMESTAMP, NUM_EXECUTIONS, TOTAL_EXEC_TIME / NUM_EXECUTIONS,  STMT_SORTS, STMT_SORTS / NUM_EXECUTIONS, STMT_TEXT, DBPARTITIONNUM FROM SYSIBMADM.SNAPDYN_SQL WHERE NUM_EXECUTIONS > 0