In article <36125DF0.54B3@netcomuk.co.uk>, Neil Truby
<ntruby@netcomuk.co.uk> writes
>kroy@Celestica.com wrote:
>>
>>
>> We recently moved new software onto our system. This new software causes
>> the system
>> to run extremely slow. Operations that would take 5 secs, now take 10 min.
>> Unfortunately, we aren't receiving any errors from our software or from
>> informix.
>Have you done an UPDATE STATISTICS?
>
>>
>> How can we determine what is causing our oninit to spin? Is that a way to
>> determine
>> what command is being executed in oninit?
>onstat -g ses sessionnumber>
>Neil Truby
>aracnet Limited
>London, UK
Check $INFORMIXDIR/etc/$ONCONFIG that OPTCOMPIND=0...
Run Art Kagel's dostats.ec from www.iiug.org
[Thanks for the mention in the version history Art!!!]
--
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