Re: Buffwaits

> Can some one tell me what buffwaits in the tbstat -p output is? The > manual says it's the number of times that a user process has to wait on > a buffer. My question is whether the process is waiting on the contents > of a buffer > (I wouldn't think so) or if it is waiting for a buffer to be freed? The latter. > Assuming the latter, increasing the number of buffers should cut down on > buffwaits - right? Probably, but you may need to juggle the LRU parameters as well. akent@cix.compulink.co.uk (Andy Kent) ------------------------------------------------ Freelance Informix Database Specialist, Redland, Bristol, England