Hey all...for better or worse (worse) we have a bunch of little apps that run as informix. Is there a way to tie the sessions (all running as informix) back to the machine/ip address that started them? That would allow me some ability to know who is doing what in what right now seems like a black box environment.
-thanks in advance

onstat -g ses


This will give you info about the pid, etc. You can use the 'ps' command in Unix to track back through calling processes if you need to.

Thanks!

What I really want to do is tie the session info back to an IP address (or something!) if possible. This is a intel environment so tty's are few and far in between and I have all these users running apps that signon as informix and it makes them way to anonymous!

And before anyone says it, changing the apps is a losing fight here due to the development staffs project load and priorities...I know theres a cadilac methodology/infrastructure/security standard that would solve all of these probs, but its out of my control so I am looking for a bandaid solution.

Sorry to be a pain and I am no informix guru.
-thanks

I've been around this topic before. Unfortunately, there's no way to derive an IP address from a session. According to the developers there's several "good" reasons why they don't. Even the "TTY", which is retained by Informix is unreliable because Informix only keeps eight characters and the folks who configure PC's have gone to some very descriptive (no them) names where the only thing that really matters has been truncated.