sp_who2
sp_who2
(OP)
Is there an informix command that does the equivent of sp_who2(mssql) in informix???
tia
tia
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS Contact USThanks. 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. Posting Guidelines |
|
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.
RE: sp_who2
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 ...
RE: sp_who2
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)
Good luck!
IDS2000