RE: Informix 7.24UC8 performance

I didnt think buffer priority management was implemented until 7.3. Not positive on that though. I would do an onstat -u on the shared memory dump and find out who was doing lots of reads or writes. If someone was analyze what they were doing. onstat -P | tailwill tell you data distributions (if Btree is a high percentatge, then maybe buffer priority management occured in 7.2x and that was your problem) onstat -g act would tell you active threads, then you might beable to work from their to find your culprit too. Hope this helps Will >===== Original Message From watawinona@aol.com (Watawinona) ===== >Check your onstat -R, sometimes BUFFERS will get loaded with index pages such >that users then compete for placing data pages. There is an environment >variable that can be set to prevent index pages from having a higher priority >over data pages - call tech support for the name of the variable. > >Nona ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------