Re: 7.22 onstat -u flags

In article <3326ED29.32C7@worldaccess.nl>, Gert van Eck <gvaneck@worldaccess.nl> writes >Allen W. Jantzen wrote: >> >> Well, I finally moved my production db to 7.22 from 5.03. After >> (finally) remembering to do an UPDATE STATISTICS and tuning >> the parameters, things seem OK, but a bit slower than ver 5.. >> >> My question: the onstat -u output has a "Y" in the first slot of the >> flags column for _all_ my client processes almost all the time. >> >> The doc just says that a "Y" means that the process is waiting on a >> condition. What condition???? >> >> Does it mean waiting in the sense that it is being held up by >> something, or waiting in the sense that it is idle and has nothing to >> do?? >> >> It is normal to see all these all these "Y"'s in the first flag slot?? >> Or should this slot be empty most of the time?? >> >> Any help appreciated. >> A perplexed DBA >> >> Please reply to allenj@ndr.com > >I even asked Informix support in The Netherlands but even they do not >come up with a clear answer > >gvaneck@worldaccess.nl A condition is a mutex (latch). Look in $INFORMIXDIR/etc/sysmaster.sql as search for "create table sysconlst". This is "{ Conditions }" and contains one field "con_nwaits integer, { number of waits on this mutex }". Try running onstat -s and compare the address field from this output with the wait field from onstat -u. onstat -g ath will show what the threads are doing and if they are waiting. -- David Williams