DB2 for LUW Continues to Mature -- MONREPORT Reporting Module

For 12 years I have written my own Top 10 SQL ranking queries and have freely provided it at many conferences and as part of my book. I am glad to see in DB2 9.7 IBM has incorporated a lot of my types of queries into the MONREPORT reporting module....

You call the SP as follows and the default collection period is either now, 10 seconds or you can specify it:

For ranking the Top 10 SQL, use the following:

from the package cache:

call monreport.pkgcache

for what is currently executing,

call monreport.currentsql (note only reports on UOW Executing)

Other options are for connections, lockwait and currentapps, as follows:

Disclaimer: Blog contents express the viewpoints of their independent authors and
are not reviewed for correctness or accuracy by
Toolbox for IT. Any opinions, comments, solutions or other commentary
expressed by blog authors are not endorsed or recommended by
Toolbox for IT
or any vendor. If you feel a blog entry is inappropriate,
click here to notify
Toolbox for IT.