Re: Q:How to find list user sessions with database
CONWAY Graham wrote:
>
> 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.
A quick scan of $INFORMIXDIR/etc/sysmaster.sql reveals there are two
potential tables which contain a database name together with a session
id:
sysopendb
syssqlstat
You can join these to syssessions or syssesprof, or whatever takes your
fancy, via the session id.
Hope that helps,
--
Mark.
+----------------------------------------------------------+-----------+
|Mark D. Stock - Informix SA http://www.informix.com |//////// /|
|mailto:mdstock@informix.com http://www.iiug.org |///// / //|
| +-----------------------------------+//// / ///|
| Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////|
| Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////|
|Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////|
+----------------------+-----------------------------------+-----------+