Hi,

I want to get infromation about how many sql commands(include select, insert, delete, update) executed per second in Informix 9.4.

I know I can use onlog to estimate insert+delete+update commands per second, but how to get select commands per second?

Thanks advanced.

You can look at i/o ops per secone in onstat -g iov. I realize that this is not your optimal answer however there are also benchmarking schemas and apps that you can download for free. See Advanced Data Tools web site for starters.

Those are designed for use in performance tuning efforts. There may also be benchmark results that IBM would share with you although 9.4 is going to be hard to get anything out of them.

Hope this helps,
dan