Re: Help! what is dbaccess process doing after abnormal exited ?

--------------378F96F4EE133E754288D4AE Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Yoo, SangMin wrote: > My platform is AIX 4.1.4 on IBM RS6000. > I use informix 7.20 UC3. > After dbaccess is exited abnormally without doing anything, > this dbaccess process is not downed but it use heavy CPU resource. > Why? > What is dbaccess with abnormal exited doing ? > Is this a bug on informix 7.20 UC3 or AIX 4.1.4 ? > Help me!!!! > Thanks. I just had to deal with this today. What happens is that your system spends a lot of CPU time trying to read the port. If you get the session ID and do an onmode -k sessid, it should kill the session. Then you can kill the process without taking down the database. If you have Joe's "Informix Database Administrator's Survival Guide", it's covered in there on ... ah, starting on page 219. If you run onperf, you'll see a lot more system CPU time than usual. -- Marty Allred Informix DBA, Orchestrate.com --------------378F96F4EE133E754288D4AE Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit <HTML> Yoo, SangMin wrote: <BLOCKQUOTE TYPE=CITE>My platform is AIX 4.1.4 on IBM RS6000. <BR>I use informix 7.20 UC3. <BR>After dbaccess is exited abnormally without doing anything, <BR>this dbaccess process is not downed but it use heavy CPU resource. <BR>Why? <BR>What is dbaccess with abnormal exited doing ? <BR>Is this a bug on informix 7.20 UC3 or AIX 4.1.4 ? <BR>Help me!!!! <BR>Thanks.</BLOCKQUOTE> &nbsp;I just had to deal with this today. What happens is that your system spends a lot of CPU time trying to read the port. If you get the session ID and do an onmode -k sessid, it should kill the session. Then you can kill the process without taking down the database. <P>If you have Joe's "Informix Database Administrator's Survival Guide", it's covered in there on ... ah, starting on page 219.&nbsp; If you run onperf, you'll see a lot more system CPU time than usual. <BR>&nbsp; <PRE>--&nbsp; Marty Allred Informix DBA, Orchestrate.com</PRE> &nbsp;</HTML> --------------378F96F4EE133E754288D4AE--