Re: Performance v11.70.fc3

You're correct, at least for one of them. RA_PAGES is still used if AUTO_READAHEAD is set to 0. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Sep 22, 2011 at 7:23 AM, Dan Mueller <Dan.Mueller@trnswrks.com>wrote: > According to IBM support just yesterday, RA_PAGES & RA_THRESHHOLS are no > longer looked by the engine in 11.7. > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art > Kagel > Sent: Wednesday, September 21, 2011 6:40 PM > To: ids@iiug.org > Subject: Re: Performance v11.70.fc3 [24988] > > Try disabling the new automatic readahead if you have not already and add > back > the older RA_ parameters. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > do not reflect on my employer, Advanced DataTools, the IIUG, nor any other > organization with which I am associated either explicitly, implicitly, or > by > inference. Neither do those opinions reflect those of other individuals > affiliated with any entity with which I am affiliated nor those of the > entities themselves. > > On Wed, Sep 21, 2011 at 3:36 PM, Peter_Logan@spartanstores.com < > Peter_Logan@spartanstores.com> wrote: > > > IDS: v11.70.fc3x3 > > OS: Aix 6.1 > > > > We have been running on the above configuration for about a month now. > > We have had several issues relating to the automatic read ahead, hence > > the X3 patch. We are also having significant performance issues > > especially when working with temp tables. We have a large number of > > Micro Strategies reports that build numerous temp tables and then join > them > all at the end. > > The time on a large number of these has increased dramatically with > > the new release. Prior we were on v11.50.fc7. I moved this database to > > v11.70.fc2 and things performed as they did in 11.50. I'm guessing > > that the issue may have to do with changes made to temp tables and > > such. Some of these queries have gone from 70 seconds to 13 minutes. > > Not the right direction! Anyway, I'm just asking generally if those > > who have moved to this release have seen any similar issues, and if > > so, were you able to get things working properly. Stats have been > > updated and such so it's not that sort of thing. I have IBM looking > > into it, but also wanted to get input from the user community. > > > > Thanks for any and all responses ... > > > > Peter Logan > > Senior Database Administrator > > Phone: 616/878-8309 > > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --90e6ba6e8bea0dd12404ad7b4006 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --90e6ba6e8ab81b83f904ad86fe6e