Performance measurement

[pankaj.puranik]

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?    ::)  ;)

[frasert]

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

[pankaj.puranik]

What does each of the following mean?
real, user and sys?

[Justin Derrick]

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.

[dr_te_z]

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