OnDemand User Group
Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News:
Home
Help
Search
Calendar
Login
Register
OnDemand User Group
»
Off Topic
»
General
(Moderator:
geoffwilde
) »
Performance measurement
« previous
next »
Print
Pages: [
1
]
Author
Topic: Performance measurement (Read 6427 times)
pankaj.puranik
Guest
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
Guest
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: 2231
CMOD Guru for hire...
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
Print
Pages: [
1
]
« previous
next »
OnDemand User Group
»
Off Topic
»
General
(Moderator:
geoffwilde
) »
Performance measurement