Re: KILL SESSIONS

Couldn't one just do an onstat -k and find which sessions are having a shared lock on the database and kill those ? For me, yea, bounce the engine is the quickest, but just for sake of argument.... ======================== -<<Floyd Wellershaus>>- Database Administrator Unix Administrator email: fwellers@yahoo.com Home: 703-430-0805 Cell: 703-477-6045 ======================== http://www.one.org/ ----- Original Message ---- From: Keith Simmons <smiley73@googlemail.com> To: Informix-list@iiug.org Sent: Friday, April 13, 2007 4:32:47 AM Subject: Re: KILL SESSIONS On 13/04/07, Drazen Kruhek <drazen.kruhek@trgocentar.com> wrote: > something without restarting engine? > why informix didn't have options onmode -z all or something? > ----- Original Message ----- > From: "Keith Simmons" <smiley73@googlemail.com> > Newsgroups: comp.databases.informix > To: <Informix-list@iiug.org> > Sent: Friday, April 13, 2007 10:00 AM > Subject: Re: KILL SESSIONS > > > > On 13/04/07, Dray <drazen.kruhek@trgocentar.com> wrote: > >> How to kill all sessions in one time on IDS 9.4! > >> I doing dbexport database ,but some sesionss is active(user is not end a > >> aplication) so i can't do dbexport. > >> > >> > >> _______________________________________________ > >> Informix-list mailing list > >> Informix-list@iiug.org > >> http://www.iiug.org/mailman/listinfo/informix-list > >> > > onmode -yuck to stop the engine and terminate all sessions> > oninit to restart engine then dbexport quickly before anyone has a > > chance to connect ! > > Don't forget no one else will be able to connect until the export has > > completed, which may be some considerable time. > > > > Keith > Don't know why, but it would not be simple. Even the init sessions appear in the session list the same as all other connections so it would be awkward to determine what should be retained and what should be terminated. You either have to restart the engine (what is the problem with this?) or manually terminate every application session. Why are you exporting, what are you tryng to achieve? Just seen next message ! Under windoze you need to use services to stop and restart the engine not command line. (Sorry, I'm unix) Keith _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list