Q:How to find list user sessions with database

Posted in 1998

CONWAY Graham — Wed, 15 Jul 1998 10:09:07 +0200 — source: Informix-list mailing list archive (1991-1998)

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

Related threads

record locked
who locks a record?