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

--------------94BC391C1121626A90B2F1EC Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Marty Allred wrote: > 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. WHOA!! What I meant to say was "onmode -z sessid", NOT "-k"!! If you did use the -k flag and then said yes to the Do you want to shutdown question, and had problems, please accept my deepest apologies. If you need the session id, it's the sid column in the sysmaster database in the syssessions table. This table also has username and pid for using to find the sid. -- Marty Allred Informix DBA, Orchestrate.com --------------94BC391C1121626A90B2F1EC Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit <HTML> Marty Allred wrote: <BLOCKQUOTE TYPE=CITE>&nbsp;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.</BLOCKQUOTE> WHOA!! What I meant to say was "onmode -<B>z</B> sessid", NOT "-k"!!&nbsp; If you did use the -k flag and then said yes to the Do you want to shutdown question, and had problems, please accept my deepest apologies. <P>If you need the session id, it's the sid column in the sysmaster database in the syssessions table. This table also has username and pid for using to find the sid. <PRE>--&nbsp; Marty Allred Informix DBA, Orchestrate.com</PRE> &nbsp;</HTML> --------------94BC391C1121626A90B2F1EC--