Re: Poor performance after upgrade from Online 7.1 to 7.23

On Fri, 8 May 1998 20:42:27 -0500, "Robert Griffin" <rag4@mead.com> wrote: >yes. update statiscs low. That's definetly not enough. Go to the software archives at http://www.iiug.org and get the utils2_ak library. Extract it and compile and use the dostats command. That will give you all the correct update statistics commands you need to run. You can also check your release notes as well as some of the posts on this issue here in c.d.i. Go to http://www.dejanews.com and search on posts made by Art Kagel on this subject. He wrote the dostats command and knows all the intricate details of update statistics. >BlackStar wrote in message <35512b75.8443180@news>... >>Have you done UPDATE STATISTICS on the DBs? >> >> >>On Wed, 6 May 1998 19:45:21 -0500, "Robert Griffin" <rag4@mead.com> >>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 >>> >>> >>> >> >>Standard Disclaimer > > Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)