Informix

nested-group-icon.png

DB2

Expand all | Collapse all

Slow Running Query

  • 1.  Slow Running Query

    Posted 4 days ago
    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
    ------------------------------


  • 2.  RE: Slow Running Query

    Posted 4 days ago

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


    Regards
    Amit P

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



  • 3.  RE: Slow Running Query

    Posted 3 days ago
    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
    ------------------------------