SQL Command to obtain the Top Ten of SELECT SQL sentences with more execution time in your DB2 database:
db2 "SELECT AVERAGE_EXECUTION_TIME_S as TIME_SECONDS,
NUM_EXECUTIONS as EXECUTIONS,
STMT_TEXT as TEXT
FROM SYSIBMADM.TOP_DYNAMIC_SQL
WHERE upper(STMT_TEXT) like 'SELECT%'
ORDER BY AVERAGE_EXECUTION_TIME_S DESC
FETCH FIRST 10 ROWS ONLY"
