"defunct" processes in Solaris
This is a multi-part message in MIME format. ------=_NextPart_000_0255_01BDD665.94DC2BE0 Content-Type: text/plain; charset="windows-1251" Content-Transfer-Encoding: quoted-printable Hello! I use Informix OnLine 5.0 under Solaris 2.5.1. My application works each = day from the morning to the evening and each 5 seconds reads new = records, appeared in DB (written there by another application). I use = Dirty Read Isolation Level. As I've understood, sometimes I obtain a = number of "defunct" processes born by my application. The number of = "defunct" processes may increase greatly and even stop DB. Don't you = know what's the reason of such a behavior and how I can avoid it? Does = that mean that I must start another process under Solaris that could = keep trace about all "defunct" processes, having arisen from my = application, and kill them? Is there any more pleasant way within the = same application? 2. I read new records from DB view each 5 seconds, analyzing the column = with record time creation value. Sometimes I may lose a record. For = example, if I fetch all rows, created between 16:00:08 and 16:00:12 at = the time moment 16:00:13, I lose sometimes a row with value "16:00:12" = in the column. How can I escape from this situation? Will committed Read = Isolation help me or not? Thank you in advance if anybody helps, Irina Irina Kotlova RESEARCH & TRADE RUSSIA e-mail: irina@accom.ru , irina@rtr.transit.ru phone: +7 095 959-43-13 (additional 24) ------=_NextPart_000_0255_01BDD665.94DC2BE0 Content-Type: text/html; charset="windows-1251" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN"> <HTML> <HEAD> <META content=3D"text/html; charset=3Dwindows-1251" = http-equiv=3DContent-Type> <META content=3D'"MSHTML 4.71.1712.3"' name=3DGENERATOR> </HEAD> <BODY bgColor=3D#d1f1f8> <DIV><FONT color=3D#000000>Hello!</FONT></DIV> <DIV><FONT color=3D#000000></FONT> </DIV> <DIV>I use Informix OnLine 5.0 under Solaris 2.5.1. My application works = each=20 day from the morning to the evening and each 5 seconds reads new = records,=20 appeared in DB (written there by another application). I use Dirty Read=20 Isolation Level. As I've understood, sometimes I obtain a number of=20 "defunct" processes born by my application. The number of=20 "defunct" processes may increase greatly and even stop DB. = Don't you=20 know what's the reason of such a behavior and how I can avoid it? Does = that mean=20 that I must start another process under Solaris that could keep trace = about all=20 "defunct" processes, having <FONT color=3D#000000>arisen = </FONT>from my=20 application, and kill them? Is there any more pleasant way within the = same=20 application?</DIV> <DIV> </DIV> <DIV>2. I read new records from DB view each 5 seconds, <FONT=20 color=3D#000000>analyzing </FONT>the column with record time creation = value.=20 Sometimes I may lose a record. For example, if I fetch all rows, created = between=20 16:00:08 and 16:00:12 at the time moment 16:00:13, I lose sometimes a = row with=20 value "16:00:12" in the column. How can I escape from this = situation?=20 Will committed Read Isolation help me or not?</DIV> <DIV> </DIV> <DIV>Thank you in advance if anybody helps,</DIV> <DIV>Irina</DIV> <DIV><FONT color=3D#000000><BR>Irina Kotlova<BR>RESEARCH & TRADE=20 RUSSIA<BR>e-mail: <A href=3D"mailto:irina@accom.ru">irina@accom.ru</A> , = <A=20 href=3D"mailto:irina@rtr.transit.ru">irina@rtr.transit.ru</A><BR>phone: = +7 095=20 959-43-13 (additional 24)<BR></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0255_01BDD665.94DC2BE0--