« previous next »
Pages: [1]

Author Topic: Performance measurement  (Read 6024 times)

pankaj.puranik

  • Sr. Member
  • ****
  • Posts: 374
    • View Profile
Performance measurement
« 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?    ::)  ;)
Logged

frasert

  • Guest
Re: Performance measurement
« Reply #1 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
Logged

pankaj.puranik

  • Sr. Member
  • ****
  • Posts: 374
    • View Profile
Re: Performance measurement
« Reply #2 on: February 08, 2011, 11:18:16 PM »
What does each of the following mean?
real, user and sys?
Logged

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2229
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Performance measurement
« Reply #3 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.
Logged
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

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

dr_te_z

  • Guest
Re: Performance measurement
« Reply #4 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
Logged
Pages: [1]
« previous next »