DB2 LUW tools for diagnosing issues when the stuff hits the fan
- by Ichorus
I am no DBA and very much a novice when it comes to DB2 so even 'obvious' answers are welcome to this question:
I love db2top but sometimes I cannot get it to run if the load average is high on a db2 LUW.
This morning I was looking at an issue where load average shot up suddenly, I could not get db2top to come up and I needed to find out what was happening.
What can I do to find out who is doing what in this situation? I suspected a horribly bad query was being run by someone...is there a good way to find information on poor performing SQL on the fly in that type of situation?
Are there any good ways to collect good, actionable stats who/where bad sql is coming from in the event that load average is so high? I know about db2pd but I am not sure how to use it effectively and slogging through tens of thousands of lines of raw data is probably not the most efficient way to get at the heart of a problem.
Any tips or resources?