Informix performing tuning scripts on Solaris?

mixxalot · #1 (**permalink**) 06-22-04, 14:59

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

artemka · #2 (**permalink**) 06-22-04, 17:09

Check out

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

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

mixxalot · #3 (**permalink**) 06-22-04, 22:11

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

gurey · #4 (**permalink**) 06-23-04, 08:19

Hi Scott J.,

Please test with onstat -g iof.

Gustavo.

Internet Services

Web Development

Digital Marketing

Consumer Tech