Good morning All,

  Kindly le t me know , if I run "onstat -g act -r 2" and get multiple rows with some RSTCB values , so how can we check which SQL causing to run slow query.

Because it will be tough to check which RSTCB value is constant among  multiple rows. 


Thanks
Amit Patel

------------------------------
AMIT PATEL
------------------------------

#Informix

If like multiple rows , then how can be checked which thread id we need to compare ?


Regards
Amit P

------------------------------
AMIT PATEL
------------------------------

Instead of using -r2 run the onstat in a loop with a sleep and write each output to a different file. Then you can diff the files to find the long runners:

iter=0;
while [ $iter -lt 10 ]; do
  onstat -g act >act.$iter.out
  sleep 2
  iter=$(( iter + 1 ))
done

You could also enable SQLTRACE and poll the data from there periodically to determine long running queries. Also there are 3rd part applications that will track that for you: iWatch and SQL PowerTools

------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
------------------------------