Results 1 to 2 of 2

Thread: SQL Statments

  1. #1
    Join Date
    Oct 2002
    Location
    Pakistan (Lahore)
    Posts
    16

    Cool Unanswered: SQL Statments

    Hello All

    Is there any way to know how many users are currently connected to database and their statu through SQL statment?


    wicky

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Yes, it can be done through the System Monitoring Interface (SMI) tables. I believe it is the syssessions table. Since you have not worked with this before, I would spend some time getting acquainted with it and the risks. A good reference book for Informix is The Informix Handbook - it is expensive but worth it ($100) - try bookpool.com for cheap technical books.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •