Performance measurement

Previous topic - Next topic

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.
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Webinars:  https://CMOD.Training/
IBM CMOD Professional Services: https://CMOD.cloud

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

dr_te_z

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