Re: how to tune buffer allocated to index data?

LRAGE=1 resolves the problem in 7.31. Its never been "fixed". New buffer management code in 9.X means the problem doesn't repro. "Simmons, Keith" <keith.simmons@office2office.biz> wrote in message news:<c2s2cq$c0u$1@terabinaries.xmission.com>... > Miyaki > > You are encountering Bug 121515 where the LRU Queues get clogged with index > pages rather than being used for data pages. Work around is to export the > environmental variable LRUAGE=1 in the session you use to start the engine. > I'm not sure at which version this was fixed (if at all) but I am still > using the parameter at 7.31 UD5 and can find no reference to it being fixed. > > Keith > > -> -----Original Message----- > -> From: miyaki [mailto:lcib@yahoo.com] > -> Sent: Friday, March 12, 2004 3:53 AM > -> To: ids@iiug.org; informix-list@iiug.org > -> Subject: how to tune buffer allocated to index data? > -> > -> > -> Hi all, > -> > -> I noticed that the buffer allocated to the index data > -> was extremely high in my database (version 7.31.UC2). > -> May I know which parameter (in onconfig) manage this > -> buffer and how to tune it? > -> > -> Percentages: > -> Data 12.16 > -> Btree 86.52 > -> Other 1.32 > -> > -> TIA, > -> Miyaki > -> > -> __________________________________ > -> Do you Yahoo!? > -> Yahoo! Search - Find what you're looking for faster > -> http://search.yahoo.com > -> sending to informix-list > -> > > > ********************************************************************************** > This message is sent in strict confidence for the addressee only. It may > contain legally privileged information. The contents are not to be disclosed > to anyone other than the addressee. Unauthorised recipients are requested > to preserve this confidentiality and to advise the sender immediately of any > error in transmission. > This footnote also confirms that this email message has been swept for the > presence of computer viruses, however we cannot guarantee that this message > is free from such problems. > ********************************************************************************** > > sending to informix-list