Re: Monitor tools
In article <6j9u66$d1i$1@news.xmission.com>, Eric Urff
<urff@dbcc.cc.fl.us> writes
>
>Are there any good tools to monitor the performance of Informix. We are =
>running 7.2 on HP-UX and the engine has a tendency to go a crawl and there =
>appears to be no way to decipher the culprit easily.. Any ideas?
>
>
Run querys in dbaccess with
SET EXPLAIN ON;
first and look at the sqexplain.out file, check the right indexes
are being used.
Check in $ONCONFIG that OPTCOMPIND=0.
[When will Informix change the default, most people want to use
indexes, not sequenatial scans of large tables and dynamic hash
joins!! Please someone put in a feature request and make it count!!].
>
>Eric Urff
>urff@dbcc.cc.fl.us
>Director of Information Systems
>Daytona Beach Community College
>(904)253-3026
>
--
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