how many transactions/sql statements server has executed

Hi I'd like find out how many transactions and/or sql-satements Informix instance has executed in a given period of time. Seem's that this information is not easily accessible but I hope that you experts find a way.. Thanks in advance Pentti

On 23 Apr, 09:09, LonelyWolf <lonelywolf1...@gmail.com> wrote: > Hi > > I'd like find out how many transactions and/or sql-satements Informix > instance has executed in a given period of time. Seem's that this > information is not easily accessible but I hope that you experts find > a way.. > > Thanks in advance > Pentti For transactions onstat -p and check how many commits/rollbacks occured. For sql statements use version 11.50 and Sthe SQLTRACE onconfig parameter to track say the last 1,000 sql statements, you can then query the syssqltrace table in the sysmaster database to get sql_finishtime and sql_runtime.

On 23 huhti, 20:54, "da...@smooth1.co.uk" <da...@smooth1.co.uk> wrote: > On 23 Apr, 09:09, LonelyWolf <lonelywolf1...@gmail.com> wrote: > > > Hi > > > I'd like find out how many transactions and/or sql-satements Informix > > instance has executed in a given period of time. Seem's that this > > information is not easily accessible but I hope that you experts find > > a way.. > > > Thanks in advance > > Pentti > > For transactions onstat -p and check how many commits/rollbacks > occured. > > For sql statements use version 11.50 and Sthe SQLTRACE onconfig > parameter to track say the last 1,000 sql statements, > you can then query the syssqltrace table in the sysmaster database to > get sql_finishtime and sql_runtime. Thanks David! I made a quick look to onstat -p statistics and those numbers seems to be a bit low. I have to study further if there is a lot of traffic outside transactions. We don't have 11.50 version i production (yet) so I can't use the SQLTRACE just now.