AW: find session_id, ip, machinename
onstat -g sql shows session id (SID) and database.
onstat -g ses shows SID, user, process id (PID) and hostname.
Type onstat -g sql SID or onstat -g ses SID to get more info about a single
session.
-----Ursprüngliche Nachricht-----
Von: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org]Im Auftrag von Fotopoulos Lefteris
Gesendet am: Montag, 13. November 2006 12:39
An: informix-list@iiug.org
Betreff: find session_id, ip, machinename
Hello,
How to find sid, or ip address or machine name of client executing a query?
Eleftherios Fotopoulos
OBI-IT Information Services
*: 210-6183614
*: lfot@obi.gr
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************