RE: What is "cond wait(sm_read)" ?

I am using 7.30, but I think this applies to 9.x as well. 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 :) I used 'onstat -g con' to observe this. Will >===== Original Message From Geoffrey Poole <Geoffrey.Poole@ogs.co.uk> ===== >Dear all, >Universal Server 9.14.UC2 (to be UC7 after Y2K!), Sun E450 x 4CPUs, Solaris >2.6 > >I have a session that has just started to run very slow and I'm trying to >understand why. >The session is waiting on condition "sm_read". I know about the sm_poll, >sm_listen, sm_discon threads but not about the sm_read "thread" ? Is >Informix simply waiting on the client program, which is at the other end of >a socket connection, to tell it what to do next - like condition "netnorm" ? >i.e. the problem is in the client (which is a JIG Server - >Java-Illustra-Gateway -> I'll be impressed if anyone knows of this legacy >s/w!). > >INFORMIX-Universal Server Version 9.14.UC2 -- On-Line -- Up 07:56:38 -- >322568 Kbytes > >session #RSAM total used >id user tty pid hostname threads memory memory >18282 informix - 26680 biscuit 1 303104 238912 > >tid name rstcb flags curstk status >18924 sqlexec 1667e6e8 Y--P--- 1288 1667e6e8 cond wait(sm_read) > >Memory pools count 1 >name class addr totalsize freesize #allocfrag #freefrag >18282 V 16c0a018 303104 64192 479 12 > >name free used name free used > >overhead 0 120 scb 0 128 > >opentable 0 10072 filetable 0 1592 > >ru 0 224 log 0 2152 > >temprec 0 13896 keys 0 152 > >ralloc 0 170368 gentcb 0 8528 > >ostcb 0 2016 sort 0 56 > >sqscb 0 13552 rdahead 0 1600 > >hashfiletab 0 280 osenv 0 1608 > >buft_buffer 0 4272 sqtcb 0 3352 > >fragman 0 4120 shmblklist 0 456 > > >Sess SQL Current Iso Lock SQL ISAM F.E. >Id Stmt type Database Lvl Mode ERR ERR Vers >18282 SELECT live DR Not Wait 0 0 9.03 > >Current statement name : curs17 > >Current SQL statement : > simple select on temporary table > >Geoff Poole >Informix Database Administrator >geoffrey.poole@ogs.co.uk >Oxford GlycoSciences ------------------------------------------------------------ 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/ ------------------------------------------------------------