[Info-ingres] Number and Size of Transactions

[Steve]

On Monday, 20 January 2020 20:00:21 UTC+11, Roy Hann  wrote:
> Steve wrote:
> 
> > A colleague is asking for information on the number of transactions
> > our Ingres database processes as well as the size of the transactions
> > (not even quite sure what that means). Any suggestions how I might find
> > this information? Is this something I could get from IMA?
> 
> You can easily get the number of transactions processed in an interval
> and you can get it from IMA if you need to. The simplest way to get it
> though, would be to execute 
> 
>    logstat -statistics
> 
> The "Transaction ends" counter is what you are interested in.
> 
> If you want to know the cumulative "size" of the transactions look at
> "Kbytes written". That may not mean what your colleague hopes it means
> though, because it doesn't distinguish all the records written for
> non-updating transactions. It also includes everything done by
> transactions that ultimately got rolled back.
> 
> Roy

Great, thanks Roy.

I actually answered my own question. I got the transaction log information using the Interval menu option in the Logging System Summary Screen in ipm.

However, I do have one question. Am I correct in thinking that the amount written and read from the transaction log has no correlation to the amount written and read to the data files holding the table data?