OnDemand User Group

Off Topic => General => Topic started by: pankaj.puranik on February 06, 2011, 10:41:19 PM

Title: Performance measurement
Post by: pankaj.puranik on February 06, 2011, 10:41:19 PM

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

Title: Re: Performance measurement
Post by: frasert on February 08, 2011, 08:57:59 AM

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

Title: Re: Performance measurement
Post by: pankaj.puranik on February 08, 2011, 11:18:16 PM

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

Title: Re: Performance measurement
Post by: Justin Derrick on February 09, 2011, 07:34:20 AM

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.

Title: Re: Performance measurement
Post by: dr_te_z on April 24, 2012, 04:59:28 AM

Quote from: pankaj.puranik on February 06, 2011, 10:41:19 PM

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