Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Posts
    369

    Unanswered: Informix performing tuning scripts on Solaris?

    Hi all,

    I am new to Informix and looking for some good basic Informix performance tuning scripts. We are running Informix 9.4 IDS server on Sun Solaris 2.6. Would like to collect basic Informix tuning statistics such as I/O, dbspaces, etc. Can anyone help me out or point me in the right direction? Thanks!

    B. Scott

  2. #2
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    Check out

    http://www.advancedatatools.com/Articles/sysmast.htm

    bunch of sql scripts against sysmaster database,
    also look on www.iiug.org

  3. #3
    Join Date
    May 2003
    Posts
    369

    iostat and sar output

    Thanks a lot. I am a solid Unix DBA but mostly working with Oracle and DB2 UDB so have not done Informix in awhile. Any simple scripts would be useful. I will try to see how I can get the user group Informix scripts to run within our Informix environment from the link you posted.

    Regards,
    Scott J
    mixxalot@yahoo.com

  4. #4
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi Scott J.,

    Please test with onstat -g iof.

    Gustavo.

Posting Permissions

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