Re: Informix Performance

Larry Strickland wrote: > 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? Yes. On your onstat -u output, there is a column labelled "wait". This contains the address of the condition you are waiting for. Then run onstat -g con for the conditions with waiters, and look for your address. June -- june_t@hotmail.com Grounded in Palo Alto, living on M&M's (plain)