Re: Get Active Sessions

Omar, Thank you. Yes that seems to work. I just need to grep for the sqlexec and map that to onstat -u. Works well. Thank you very much. --David On Wed, Aug 12, 2009 at 3:14 PM, Omar Muñoz <omarmun@yahoo.com> wrote: > Hi. > > You obtain active threads by using onstat -g act. That includes user > sessions and informix's inner threads. > > I hope this works > > Omar > > --- On Wed, 8/12/09, Dave <In4MixDBA@gmail.com> wrote: > > > From: Dave <In4MixDBA@gmail.com> > > Subject: Get Active Sessions > > To: informix-list@iiug.org > > Date: Wednesday, August 12, 2009, 12:24 PM > > Hello, > > > > Using either onstats or SQL to query sysmaster, how can I > > get a list > > of all active sessions. By active I mean sessions > > that are running > > something and don't just have an idle connection to the > > DB. I found > > scripts for killing idle sessions though none for getting > > active > > sessions. > > > > Using either Informix 10 or 11.50 > > > > --Dave > > _______________________________________________ > > Informix-list mailing list > > Informix-list@iiug.org > > http://www.iiug.org/mailman/listinfo/informix-list > > > > > >