Table statistics question
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 descEOF
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?
--
Jon Freeland<*>
DBA
Miller Industries, Inc.
jon@millerind.com