Informix: Tracing session’s hostname longer than 8 characters

Sometimes you like to find out the hostname/IP address the sessions that came from.

onstat -g ses only display 8 characters out the hostname.

Use below query to retrive the hostname direct from sysmaster database :-

# dbaccess sysmaster –

SQL> select sid, username, hostname from syssessions where sid=session_id

Tagged Under : , , ,

Make a Comment