Re: Table statistics question
In article <3651E294.30A6@bellsouth.net>, Carlson@WHSmith
<carlson1@bellsouth.net> writes
>-=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.
>
They do eventually. But first they wrap around and become big negative
numbers!!!
>
>John Carlson
>Informix DBA
>WHSmith USA
--
David Williams
Maintainer of the Informix FAQ
Primary site (Beta Version) http://www.smooth1.demon.co.uk
Official site http://www.iiug.org/techinfo/faq/faq_top.html
I see you standin', Standin' on your own, It's such a lonely place for you, For
you to be If you need a shoulder, Or if you need a friend, I'll be here
standing, Until the bitter end...
So don't chastise me Or think I, I mean you harm...
All I ever wanted Was for you To know that I care