Get Active Sessions

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

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 >

On 12 Aug, 18:24, Dave <In4Mix...@gmail.com> wrote: > 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 Query sysmaster table syssesprof twice some seconds apart and see if the values change.