how many transactions/sql statements server has executed

#1

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

#2

On 23 Apr, 09:09, LonelyWolf <lonelywolf1... (AT) gmail (DOT) com> wrote:

Quote:

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.

#3

On 23 huhti, 20:54, "da... (AT) smooth1 (DOT) co.uk" <da... (AT) smooth1 (DOT) co.uk> wrote:

Quote:

On 23 Apr, 09:09, LonelyWolf <lonelywolf1... (AT) gmail (DOT) 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.

#4

On Apr 29, 6:58*am, LonelyWolf <lonelywolf1... (AT) gmail (DOT) com> wrote:

Quote:

On 23 huhti, 20:54, "da... (AT) smooth1 (DOT) co.uk" <da... (AT) smooth1 (DOT) co.uk> wrote:

On 23 Apr, 09:09, LonelyWolf <lonelywolf1... (AT) gmail (DOT) 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/infoce...c/admin751.htm

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

how many transactions/sql statements server has executed

comp.databases.informix comp.databases.informix

how many transactions/sql statements server has executed - 04-23-2010 , 03:09 AM

Re: how many transactions/sql statements server has executed - 04-23-2010 , 12:54 PM

Re: how many transactions/sql statements server has executed - 04-29-2010 , 12:58 AM

Re: how many transactions/sql statements server has executed - 04-29-2010 , 12:12 PM