RE: How to find list user sessions with database

You can query the syssqlstat table in the sysmaster database it has a = sqs_sessionid column and a sqs_dbname column. You can also join to the = syssessions table to get more info if you need. Bryan Allison Greenbrier & Russel -----Original Message----- From: CONWAY Graham [SMTP:Graham.CONWAY@oami.eu.int] Sent: Wednesday, July 15, 1998 1:09 AM To: 'Informix Listserv' Subject: Q:How to find list user sessions with database Hi, Please excuse me if this is obvious. Does anyone have a simple way (sysmaster query or onstat option) of = listing the sessions on a server and the database they are currently connected = to. I have a script that does it by going through the onstat -u output and calling onstat -g sess <sessid> for each session, but there must be a quicker way. Thanks, Graham Conway OAMI Alicante