Joined: 13 Jun 2012 Posts: 162 Location: United States
I would like to sample DB2 activity to identify the heaviest used SQLs and tables. I'd like to be able to turn sampling on for 5 seconds every 10 minutes, for example. I am aware I can run reports that will give DB2 stats after the fact, if they are being captured. Hopefully, I can do this in "real time" without causing huge DB2 overhead. If someone can point me to the right place or publications, it would be appreciated.