RE: how to tune buffer allocated to index data?

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