Number of Active user sessions

Posted in 2006

in4mixDBA — 25 Aug 2006 05:53:56 -0700 — source: Usenet: comp.databases.informix

Hello, How can I query the sysmaster SMI tables to get the number of "Active" user sessions. I know that I can get the total number of user sessions from syssessions. However, I would like the "Active" sessions. Thank you in advance, Have a great day... TGIF... Dave In4MixDBA@gmail.com

↪ replying to in4mixDBA

SaltTan — 27 Aug 2006 22:52:58 -0700 — source: Usenet: comp.databases.informix

May be this query can help you It shows sessions that are not waiting for condition select s.sid from sysscblst s, sysrstcb r, systcblst t where s.sid = r.sid and t.address=r.mttcb and wtcondp = 0 in4mixDBA wrote: > Hello, > > How can I query the sysmaster SMI tables to get the number of "Active" > user sessions. I know that I can get the total number of user sessions > from syssessions. However, I would like the "Active" sessions. > > Thank you in advance, > > Have a great day... > > TGIF... > > Dave > In4MixDBA@gmail.com