Monitoring

DB2 Top 10 SQL by Number of Executions

How to obtain the top 10 SQL sorted by number of executions on your database?


DB2TOP replay

Actually DB2TOP is a real-time tool, however many DBA’s don’t know that it can be run in REPLAY mode with captured session information. So, next time you have a big crisis with your database, you can capture all the data from db2top and do the analysis afterwards.