Re: time of last onstat -z?
The stats are cleared, obviously, at startup, after that if you have cleared
them since you can look at sysshmvals.sh_pfclrtime which is a UNIX time.
However, you do not need to translate that just use:
SELECT (sh_curtime - sh_pfclrtime) Secs_Since_Reset
FROM sysshmvals;
Art S. Kagel
----- Original Message -----
From: Earle A Long <earle@btclick.com>
At: 1/ 4 11:23
> Having now written a monitoring program for the ratios mentioned in Art's
> earlier emails we are currently running at a BR of 2.81. Any comments ??
>
> Regarding the Buffer Turnovers I've got as far as the BT calculation but
> nowhere can I find the time stats were last zeroed. Is this saved anywhere
> if so where ??
>
> Buffwaits Ratio
> BR=buffwaits*100/(pagreads+bufwrits)
>
> Buffer Turnovers (BT) = (pagreads + bufwrits) / BUFFERS
> BTR = BT / (#hours since stats were last zero'd out (ie onstat -z))
> BTF = (#minutes or seconds since stats zero'd) / BT
>
> --
> Earle A Long (Senior Informix DBA)
> SINGLEPOINT UK LTD