RE: onstat -u

I was thinking about this after sending the msg...is it possible to be logged on, yet not have any active threads processing; so having the onstat -u not return anything is just showing that the user has no threads? Joe Robinson, SFC System Administrator USPFO for Oregon, Oregon Army National Guard Email: robinsonj@or-arng.ngb.army.mil <mailto:robinsonj@or-arng.ngb.army.mil> Phone: (503) 945-3776 DSN 355-3776 FAX: (503) 945-3959 DSN 355-3959 -----Original Message----- From: Vinod Bhansali [mailto:iiug@hotmail.com] Sent: Wednesday, June 07, 2000 12:34 PM To: RobinsonJ@or-arng.ngb.army.mil Subject: Re: onstat -u How do you check whether the thread is active? By onstat -g ath? Thanks Vinod >From: RobinsonJ@or-arng.ngb.army.mil <mailto:RobinsonJ@or-arng.ngb.army.mil> >To: informix-list@iiug.org <mailto:informix-list@iiug.org> >Subject: onstat -u >Date: Wed, 7 Jun 2000 11:36:45 -0700 > >I have a telnet user who consistently is walking out the door without >logging off. Here's how I assume I should go about killing the user, with >the problem listed below. > >1. Do a who -u | grep username (identify tty port) > >2. Do a onstat -u | grep username (to identify session id) > >3. After verifying thread is not active, I'd do a onmode -z session id >to kill thread > >4. By my reading, I should be able to do another onstat -u | grep to >check that the thread is no longer active. > >5. Kill user process. > >My question: I know the user is logged in, but by doing onstat -u, I don't >see anything reported back...is there a different command I can use to >identify the session id? > >Thanks for the help, > >Joe Robinson, SFC >System Administrator >USPFO for Oregon, Oregon Army National Guard >Email: robinsonj@or-arng.ngb.army.mil <mailto:robinsonj@or-arng.ngb.army.mil> ><mailto:robinsonj@or-arng.ngb.army.mil <mailto:robinsonj@or-arng.ngb.army.mil> > >Phone: (503) 945-3776 DSN 355-3776 >FAX: (503) 945-3959 DSN 355-3959 ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com <http://www.hotmail.com>;

Joe, That sounds right. I mean you can be logged on (in the telnet world) but not started anything that needs a connection to the database. Or for that matter maybe they started isql/dbaccess and just haven't selected a database yet.. Well cheers from a Beaverton, OR worker... Dave In article <8hmca2$7p6$1@news.xmission.com>, RobinsonJ@or-arng.ngb.army.mil wrote: > > I was thinking about this after sending the msg...is it possible to be > logged on, yet not have any active threads processing; so having the onstat> -u not return anything is just showing that the user has no threads? > > Joe Robinson, SFC > System Administrator > USPFO for Oregon, Oregon Army National Guard > Email: robinsonj@or-arng.ngb.army.mil > <mailto:robinsonj@or-arng.ngb.army.mil> > Phone: (503) 945-3776 DSN 355-3776 > FAX: (503) 945-3959 DSN 355-3959 > > -----Original Message----- > From: Vinod Bhansali [mailto:iiug@hotmail.com] > Sent: Wednesday, June 07, 2000 12:34 PM > To: RobinsonJ@or-arng.ngb.army.mil > Subject: Re: onstat -u > > How do you check whether the thread is active? By onstat -g> ath? > > Thanks > Vinod > > >From: RobinsonJ@or-arng.ngb.army.mil > <mailto:RobinsonJ@or-arng.ngb.army.mil> > >To: informix-list@iiug.org > <mailto:informix-list@iiug.org> > >Subject: onstat -u > >Date: Wed, 7 Jun 2000 11:36:45 -0700 > > > >I have a telnet user who consistently is walking > out the door without > >logging off. Here's how I assume I should go about > killing the user, with > >the problem listed below. > > > >1. Do a who -u | grep username (identify tty > port) > > > >2. Do a onstat -u | grep username (to identify > session id) > > > >3. After verifying thread is not active, I'd do > a onmode -z session id > >to kill thread > > > >4. By my reading, I should be able to do > another onstat -u | grep to > >check that the thread is no longer active. > > > >5. Kill user process. > > > >My question: I know the user is logged in, but by > doing onstat -u, I don't > >see anything reported back...is there a different > command I can use to > >identify the session id? > > > >Thanks for the help, > > > >Joe Robinson, SFC > >System Administrator > >USPFO for Oregon, Oregon Army National Guard > >Email: robinsonj@or-arng.ngb.army.mil > <mailto:robinsonj@or-arng.ngb.army.mil> > ><mailto:robinsonj@or-arng.ngb.army.mil > <mailto:robinsonj@or-arng.ngb.army.mil> > > >Phone: (503) 945-3776 DSN 355-3776 > >FAX: (503) 945-3959 DSN 355-3959 > > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at > http://www.hotmail.com <http://www.hotmail.com>; > > Sent via Deja.com http://www.deja.com/ Before you buy.