Re: ONSTAT question

Bashar Chalabi wrote: > onstat -u (version 7.1) sometimes shows a user thread with position> 1 of the flag field set to Y. The Informix manual says it means > "Waiting for condition". I cannot find anything else. > > What is a condition, and why is my thread waiting for it? A condition is a signalling mechanism to sleep/wake/synchronise threads. The onstat -g ath listing will give a bit more info on the thread status. You may see something like: 26275 c1c102b8 c147d718 2 cond wait(netnorm) 1cpu sqlexec This is an SQL user thread waiting on a condition called netnorm and is the normal state when the backend is waiting for a frontend message via a network connection. For a shared memory connection you would see: 26276 c1c103b8 c147d718 2 cond wait(sm_read) 1cpu sqlexec You can list all the conditions and their wait info with onstat -g con. Cosmo -- simond@informix.com