Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

Query execution time

Help
2009-04-30
2013-04-05
  • HI,
    I have this sample query which I have to run on a table in different conditions. How do I get the execution time of the query, so that I can plot it for comparison?
    Thanks,
    Harsha

     
    • Hello Harsha,

      I need to understand a bit more about these different conditions...

      As you probably have seen you can get the time it takes to run a statement through the Ad Hoc.

      But if you want the TE to render these into a graph for you.

      There are 3 possible methods.

      1. Use the tutorial framework
      2. Write an XML action script.
      3. insert the times into a table and then graph the table.

      Option 3 is not preferable to me because it changes the database and 1 and 2 are dependent on what your conditions are.

      If you look at the file ./tutorials/DB2/DB_Fundamentals/Compression/Performance/actionScript/ComparePerformance.xml

      this is an XML Action panel which is a set of XML action scripts used in the tutorial framework.

      You can see it in action on page 5 of the Compression Performance tutorial found here: Learn->DB2->Database Fundamentals -> Compression -> Performance.

      That is the closes I think to what you want of what we have published.

      If you can give me a bit more information or a scenario of what you want to do it would help and then I can write up an example of how I think is the best way for me to accomplish this.

      If you don't feel comfortable to discuses this openly feel free to e-mail me matthewv(at)ca ibm com

      Regards,
      Matthew Vandenbussche