Re: doubt in onstat -g ses

bala peddi wrote: > > Could anyone please explain me the meaning of the following state of > the informix session. This the out put of > > One of the client application is connecting through ESQL/C program and > this application is will not close the informix session , it runs 7 x > 365 > days. This application reads SQL from user and submits it informix > through the existing session that it had already open > > Thia is snapshot of onstat -g ses 1123 when there is no SQL is running I've seen the same behavior from time to time. We can usually track it to an application that is reopening cursors that have never been closed. Check the code of this SQL server and make sure that there is no code path that can return to the calling function or process without closing all open cursors. Art S. Kagel