Re: Poor performance after upgrade from Online 7.1 to 7.23

In article <35520AA3.557581C1@cornell.edu>, Vic Goldberg <vg19@cornell.edu> writes >Check in the Administrator's guide, volume 2 - in the back, there's a section >on >oncheck. > Also check OPTCOMPIND=0 in your ONCONFIG file.. >Vic > >Robert Griffin wrote: > >> Greetings, >> >> We have two databases on the same rs6000 running AIX with the 7.23 Online >> engine. After our recent upgrade from Online 7.1 we experienced a huge >> performance hit. We, with the help of Informix support, found the problem >> to be a bad index in one of our larger tables. Since then we have >> discovered other, less critical speed problems that we have yet to get >> Informix support to look at. Can someone give me info on how to do this >> myself? I'm wanting to use the oncheck -cI command to verify the other >> indexes are correct, but i can't find any specifics on how to use it. Can >> someone help? >> >> By the way, this is a 'round the clock production system, so I must be >> careful. >> >> Thanks in advance for any help. >> RG > > > >-- >Vic Goldberg >Manager, DBA Team, Cornell University >(607) 254-7441 (Voice) (607) 255-6982 (Fax) > > -- 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