Re: Ready-to-run Queue

In article <557ngf$6en@cssun.mathcs.emory.edu>, mailgw!hpx400!Trevisol_R oberto/bbb_cak@gtw1.netway.com.br writes >Hi, > >I came up with a question last time I was taking a shower... > >In which system table (sysmaster database) can I find out the Online >threads ready to run. It's the same information I get with "onstat -g >rea". I guess I found some clues in systhreads view (th_state column) >and systcblst table (state column), in fact systhreads view is derived >from systcblst. Does anyone know the meaning of values for that column? >Yet is it the right way to get there? > >Any help is very appreciated. Thanks. > >Roberto Trevisol >r.trevisol@bamerindus.com.br > > Right method just not documented by Informix. Look in Online Dynamic Server Admin. Guide Volume 2 Page 39-8. It lists the table which are documented. This does not include systhreads or systcblst. This note on the bottom of the page says "Many other tables in the sysmaster database are part of the system monitoring interface but are not documented. Their schemas and column content might change from release to release." it assume there as a column in systcblst which is tid (the thread id) try matching this column to the output of onstat -g ath (all threads). -- David Williams