Question about the status of the thread

Environment: Informix 7.31 64 bits HP-UX 11i Hi, I see the output of onstat -g ses and I have one question. Please, anybody knows which is the diference between the status "sleeping(Forever)" and "sleeping(secs: 2)" ? When is "forever" and when is "secs: x" ? Thanks in advance.

On Jun 30, 2:58 pm, Peternt <roger_vi...@yahoo.es> wrote: > Environment: > > Informix 7.31 64 bits > HP-UX 11i > > Hi, > I see the output of onstat -g ses and I have one question. > Please, anybody knows which is the diference between the status > "sleeping(Forever)" and "sleeping(secs: 2)" ? > When is "forever" and when is "secs: x" ? > Thanks in advance. When a thread sleeps "forever" it will no wake up and be scheduled on it's own. It would be waiting for some other thread to wake it up for whatever resource it's waiting for when that resource is available. An example would be a thread that submits an I/O request would go to sleep "forever" and then when the I/O was completed, the thread that did the I/O would then wake the sleeping thread up (there is definitely more reasons a thread would sleep forever, but I/O was the easiest one that popped into my head). If a thread is "sleeping: x" it's has yielded running for a certain amount of time, and it isn't dependent upon another thread to wake it up before it would be placed back on the ready queue to run. Jacques Renaut IBM IDS Advanced Support APD Team