Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
sp_who2
- Thread starter bouwob
- Start date
If I remember correctly, sp_who2, is just like sp_who from MS-SQL right?
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
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
- Status