Hi there,

** Since we are evaluating to update our current server,our HW providers ask us
to send them number or transactions per second,io per second and cpu used by
informix. I see there are a lot of metrics sent by onstat, but I want to ask you
for your advice about which onstat commands are adequate to evaluate those
metrics.

** Thanks in advance

***************************** Omar Muñoz

onstat -g iof will give you IO/sec average per chunk file. The total IO/sec
for all chunks is more difficult. It will be somewhere between the average
of those averages and the total of all of them. Transactions per second you
will be better off getting from your applications. Onstat -p does reports
the number of COMMITs which represents successful transactions, however, you
have no way to know the frequency. You could run a cron to do onstat -p
appending to a file followed by an onstat -z (to clear the stats to zeros)
every hour or every 15 minutes to see your periodic transaction rates and
extrapolate the peak load transactions per second from those files. CPU
usage is reported on the onstat -g glo report by CPU VP (so per oninit
process) and in onstat -g cpu reports cpu usage be thread which you can
trace back to individual sessions or applications.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art (AT) iiug (DOT) org)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.



On Fri, Oct 29, 2010 at 3:32 PM, Omar Muñoz <omarmun (AT) yahoo (DOT) com> wrote: