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!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sp_who2

Status
Not open for further replies.
bouwob

bouwob

Programmer
Apr 12, 2006
171
US
Is there an informix command that does the equivent of sp_who2(mssql) in informix???

tia
 
Sort by date Sort by votes
you are not telling us a lot about your problem ...

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 ... :)
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top