Re: How to determine number of users/sessions?
Bob
Try the following SQL:
DATABASE sysmaster;
SELECT b.sid, b.pid, b.username, a.sqs_dbname, b.tty
FROM syssqlstat a, syssessions b
WHERE a.sqs_sessionid = b.sid
AND a.sqs_dbname = 'your_db_name';
HTH
Sujit
______________________________ Reply Separator _________________________________
Subject: How to determine number of users/sessions?
Author: bob@rsi.com at internet
Date: 9/2/98 4:13 PM
How can I query the Informix Dynamic Server inorder to determine the
number of users/sessions connected to a particular database environment?
Thaks to anyone who can answer this!
--
Bob Gorman
bob@rsi.com