×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

sp_who2

sp_who2

(OP)
Is there an informix command that does the equivent of sp_who2(mssql) in informix???

tia

RE: sp_who2

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 ... smile

RE: sp_who2

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

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.

Join Us             Close