Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    7

    Exclamation Unanswered: A strange question.

    Hi.
    I have question that may be very strange to many of you.

    I am writing monitoring program for informix server. Well I managed to see the session information (users, hosts, etc.) with sql statement but I do not know how to see the other info about the server. So if anybody knows how to see the following info via sql statement, please share your knowage.

    1. dbspaces and chunks - like the command onstat -d
    2. replication servers - like the command cdr list server
    3. Txns in queue - like the command onstat -g rqm
    4. and any userfull onstat command.

    Thanks for the advise.

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,

    I suggest you that look in sysmaster database and explor in $INFORMIXDIR/etc/sysmaster.sql.

    Gustavo.

  3. #3
    Join Date
    Nov 2003
    Posts
    7

    Smile Thanks

    Thanks a lot

  4. #4
    Join Date
    May 2004
    Location
    New York
    Posts
    248

Posting Permissions

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