DB2 Top 10 SQL for number of executions
- Read more about DB2 Top 10 SQL for number of executions
- Log in to post comments
SQL sentence to obtain the SQL TOP TEN with more executions of my BD2 database:
db2 "SELECT NUM_EXECUTIONS as EXECUTIONS,
AVERAGE_EXECUTION_TIME_S as TIME_SECONDS,
STMT_TEXT as TEXT
FROM SYSIBMADM.TOP_DYNAMIC_SQL
WHERE upper(STMT_TEXT) like 'SELECT%'
ORDER BY NUM_EXECUTIONS DESC
FETCH FIRST 10 ROWS ONLY"







Cloud computing is the new normal. Every time you are using a service or an application through an internet connection, you are using the cloud. Since most companies nowadays have part or all their databases hosted on the cloud, you ask how is the best way to do it. Migrating your database to the cloud can help you manage your workload by making your data available and easily scalable. Read on to learn about database cloud migration and tips to do it right.. 