RE: Table io rate
Hi All !
onstat -g iof is used to show chunk I/O activity, as the dbspace is notlisted use onstat -d to find it as long as both are listed in the same order.
This would show table i/o statistics if you specifically create only that
table in that specified dbspace.
Anoher method to show table i/o statistics would be to monitor the i/o
for fragments onstat -g ppf which displays the number of r/w calls per
fragment, the list will show you the partnum which in turn can be
associated with the same column in systables to get more information
about a table that is fragmented, summarize all the fragments associated
with a speficic partnum and that's it.
Yours,
----------------------------------------------------------------
Mario Estrada / SISTECO, S.A.
INFORMIX, / Phone (502) 3340214
Support Department / Fax (502) 3348447
----------------------------------------------------------------
----------
De: Sean Wong[SMTP:swong@kato.den.csci.csc.com]
Enviado: viernes 17 de enero de 1997 9:30
Para: 'informix-list@rmy.emory.edu'
Asunto: RE: Table io rate
>Sean Wong wrote:
> Can somebody give me answers on following questions:
>
>1. How can I find out disk io, e.g. read/write access for a given table
>2. How can I find out disk io, e.g. read/write access for a process
>Jon C. Vemo (jvemo@cyberspace.com) replied:
>----------------------------------------------------------------------------
>Look at 'sar' and 'onstat -D'. If your running DSA, you can also use
'>onstat -g iof'
>----------------------------------------------------------------------------