Is there an informix command that does the equivent of sp_who2(mssql) in informix???
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS
Thanks. We have received your request and will respond promptly.
Come Join Us!
Are you a
Computer / IT professional?
Join Tek-Tips Forums!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Students Click Here
Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.
Here's Why Members Love Tek-Tips Forums:
Register now while it's still free!
Already a member? Close this window and log in.
what (the hell) is sp_who2 gonna do? what is it? i guess you are talking about some other db-system .. which one?
we need more input ...
Well, if so, issuing the < onstat -g ses > Informix command,
will get you the same info from sp_who2:
The system process ID.
The status of the process (e.g., RUNNABLE, SLEEPING).
Login name of the user.
Machine name of the user.
Name of database the process is using.
The command currently being executed (e.g., SELECT, INSERT)