Re: Table statistics question
-=Eclypse=- wrote:
>
> We have the following script to get stats on our most used tables:
>
> dbaccess sysmaster << EOF
> select tabname, isreads, iswrites from sysptprof
> where isreads <> 0 or iswrites <> 0
> order by isreads desc> EOF
>
> When do the isreads and iswrites "reset" themselves? Does an
> "onstat -z" affect this? Do they reach a certain number and roll
> back to zero? Is there a better way to find this out?
>
They will reset at:
1. A reset of the engine.
2. A system reboot -- see above.
3. After 'onstat -z'.
To my knowledge, the numbers don't reset to zero on their own.
John Carlson
Informix DBA
WHSmith USA