Re: Poor performance after upgrade from Online 7.1 to 7.23

Posted in 1998

Vic Goldberg — Thu, 07 May 1998 15:25:23 -0400 — source: Informix-list mailing list archive (1991-1998)

Check in the Administrator's guide, volume 2 - in the back, there's a section on oncheck. 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)