Re: 7.22 onstat -u flags

With DSA (6.x 7.x), the onstat -g ath is probably going to give you more information about what's going on in the engine than the onstat -u. You will often see the sqlexec thread (these are the user functions) on a condition wait (sm_read) or condition wait (netnorm). This is the normal condition that the the thread will be waiting on for the client program to pass the engine some work to do. the sm_read stands for Shared Memory Read, netnorm is the tcp version of the same thing. This is the normal waiting state for a user thread and the thread will stay in that condition until the end user sends the engine a command. Subject: 7.22 onstat -u flags From: jantzen@concentric.net (Allen W. Jantzen) Date: Wed, 12 Mar 1997 03:31:17 GMT Message-ID: <332621fc.3481263@news.concentric.net> 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 Madison Pruet