Re: exclusive excess on tables problem

hello Arvind. Yes, the proceses that you look on the onstat -u for wich you don't find any local proces are accessing your databases throug the net, you can 'kill' these processes with an 'onmode -z sessid' issued by the informix user onthe database server. >From: Arvind Sharma <asharma@uswest.com> >Reply-To: Arvind Sharma <asharma@uswest.com> >To: informix-list@iiug.org >Subject: exclusive excess on tables problem >Date: Tue, 05 Oct 1999 07:40:20 -0600 > >This is a multi-part message in MIME format. >--------------6ACBA98C1792A5944B5C7443 >Content-Type: text/plain; charset=us-ascii >Content-Transfer-Encoding: 7bit > >Hi all, > This group has always helped me whenever I was in problem, I am sure >this time also I will get a solution. > Last night we had a release in which we tried to alter some tables. >But we got database error 242 and isam error 106, which means table was >used by some one else and we didn't have the exclusive access. We are >sure nobody was on the system at that time. In the morning when I >checked the output of onstat -u I found some sessions using database >though the user was not logged on. > My question is: Is it possible to kill any such type of sessions >before running the database alter commands? If yes how? Actually the >users here exit from the system without logging out properly this causes >the problems. Is there a way we can stop this from happening. Any help >will be greatly appriciated. We are using Informix 7.3x and HP-UX 10.20. > >Thanks in advance. If possible please send a copy of your reply to my >email id at asharma@uswest.com > >Thanks > >Arvind > >--------------6ACBA98C1792A5944B5C7443 >Content-Type: text/x-vcard; charset=us-ascii; > name="asharma.vcf" >Content-Transfer-Encoding: 7bit >Content-Description: Card for Arvind Sharma >Content-Disposition: attachment; > filename="asharma.vcf" > >begin:vcard >n:Sharma;Arvind >x-mozilla-html:FALSE >org:Tata Consultancy Services >version:2.1 >email;internet:asharma@uswest.com >tel;fax:303-624-0500 >tel;home:303-399-4762 >tel;work:303-624-5052 >adr;quoted-printable:;;931, 14th Street, Room #830 (work)=0D=0A900, S. >Quince St., #B511(home);Denver;Co;80231;US >x-mozilla-cpt:;56096 >fn:Arvind Sharma >end:vcard > >--------------6ACBA98C1792A5944B5C7443-- > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com