Re: Informix Performance

Speaking of this, when the 'User thread Status' shows 'Y--P---' it indicates that the process is waiting on a 'condition'. It often seems this indicates the process is waiting on some input from a user process via the network. However, this may not always be true. Is there a way of determining what said 'condition' is? Larry Strickland At 01:09 PM 11/23/98 -0500, you wrote: >gquian wrote: >> >> I'm running an application process that works abnormaly slow on Informix >> Online DS. >> I've take a look in on-monitor about user-threads. >> >> The 'User thread Status' column shows 'B--PR--' . >> >> Do you know what's happening? >> >> Should I change any parameter? > >Yup. Your process is waiting for access to a buffer. This can either >mean that you need more buffers, but more often means you need more LRU >Queues to eliminate contention for buffers. Increase the LRUS >parameter in the ONCONFIG file (avoid using 64 or 96 as these values >are suspected of triggering a bug that sends BUFWAITS through the roof). >BTW you can verify that your processes are waiting for buffers >frequently by checking the bufwaits (onstat -p) compared to bufwrites >plus dskreads. On a well tuned system the ratio of bufwaits to that >total should be low (ie only a few %). > >Art S. Kagel >