RE: Tracking conditions

I believe that this condition means that your thread is waiting for the program to submit an sql statement. In other words, if I log into dbaccess and connect to the database via shared memory this is the condition my thread is waiting on. When I am not waiting on submitted SQL When I am executing an sql, this sm_read wait condition goes away, though sometimes it is replaced by new and more interesting wait conditions :) Will Rice >===== Original Message From "Scott Hanson" <scott.hanson@NO.SPAM.supportwise.co.uk> ===== >If a thread is waiting for a resource which is a "condition", is it possible >to find out what that condition is? > >informix@Lawson $ onstat -u | grep robink >e2bdf798 Y--P--- 55397 robink - e62c2608 0 1 101 0 > >informix@Lawson $ onstat -g con | grep e62c2608 >1564623 e62c2608 sm_read 58385 1666 > >The name of this condition is "sm_read" but what is this thread waiting on? >I spoke to Informix but all they could say was it was "machine resource". > >Cheers, > >Scott >--- >Scott Hanson >SupportWise Limited >t. 07712-760679 >f. 08700-509654 >e. scott.hanson@supportwise.co.uk ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------