Hi
I want to know how is the performance of CMOD measured?
How is the response time (of a query from CMOD) is measured?
If my manager comes and asks me how much time it takes for a query to execute?
How can I do that?
Is it that I sit with a stop watch and measure the time takes? ::) ;)
If you are on AIX, you can use the 'time' command. You just prefix the command you want to run with "time":
$ time arsdoc query ....
Which will produce a result like this:
real 3m35.68s
user 3m33.66s
sys 0m1.44s
What does each of the following mean?
real, user and sys?
Very basically...
Real is actual time (ie, "wall clock")
User is time the process spent doing actual work
Sys is the time the process spent waiting for the system (i/o wait, paging, etc.)
Google for more detailed info.
-JD.
Quote from: pankaj.puranik on February 07, 2011, 05:41:19 AM
If my manager comes and asks me how much time it takes for a query to execute?
How can I do that?
You could monitor DB2. There are tools or you could take snapshots and analyse them yourselves.
This http://www.dbisoftware.com/blog/db2nightshow.php?id=350 could be interesting to watch. I did not do that myself yet but I attended his presentations during the last IDUG@prague. You could pick up a few pieces from that when you look at your CMOD/DB2 database