|
View previous topic :: View next topic
|
| Author |
Message |
John Poulakos
Active User
Joined: 13 Jun 2012
Posts: 178
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. |
|
| Back to top |
|
 |
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
| Back to top |
|
|
John Poulakos
Active User
Joined: 13 Jun 2012
Posts: 178
Location: United States
|
|
|
|
| Thank you. What I was looking for was the IFI interface, but your link lead me there. |
|
| Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
| You are welcome. |
|
| Back to top |
|
|
|
|
