I am working on DB2 V9.1 on AIX 5.3
Yesterday, the CPU utilization reached 100% and so db2pd was the only option I was left with to analyze the problem. I was asked to kill the longest running query. How do I find it considering the output of db2pd is huge and number of transactions running are 100+
Also, when i see the output of "db2pd -database <ABCD> -dynamic", I find more than 100+ statements executing under column text then why does it display only 6-7 statements while executing "db2pd -database <ABCD> -activestatements"