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

In article <35B7BD66.365343BC@tc.net>, Marty Allred <mallred@tc.net> writes >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. > Correct the read returns 0 bytes which means dbaccess retrys the read() system call!! This was also a problem under old versions of isql. ... >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 > > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care