Re: how many transactions/sql statements server has executed

On Apr 29, 6:58 am, LonelyWolf <lonelywolf1...@gmail.com> wrote: > 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.- Hide quoted text - > > - Show quoted text - hi Pentti, I'm using SQLTRACE (or rather it it's dynamic equivalent) on IDS 11.10 in 11.50 they've implemented SQLTRACE per SESSID, a GLOBAL SQLTRACE is available on 11.10 though you can enable it without restarting the engine, check http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp?topic=/com.ibm.admin.doc/admin751.htm