Informix

Expand all | Collapse all

How to configure informix to store TPS on logfile (without query on sysmaster)

  • 1.  How to configure informix to store TPS on logfile (without query on sysmaster)

    Posted Wed June 30, 2021 11:59 AM
    Hi
    I want to monitor Transaction Per Second of informix database. and need to write TPS on log file after that monitor that file.
    How configure informix to store TPS on log file  (without query on sysmaster)?

    Thanks

    ------------------------------
    Indeed_1
    ------------------------------


  • 2.  RE: How to configure informix to store TPS on logfile (without query on sysmaster)

    Posted Wed June 30, 2021 12:27 PM
    You could run an "onstat -p" and parse out the time since startup and the number of COMMITs from the output. That will not be accurate if you have reset the server's stats (onstat -z) since the server was last bounced. Also it will be skewed low if your transactions don't run at a constant rate 24x7 and so will be an average over time rather than a peak, mode, or median value which may be what you seek. You won't get better numbers out of sysmaster, although you could get around the onstat reset issue that way (sysshmvals.sh_pfclrtime).

    Better to configure your applications to keep score or add a trigger to a table that's included in every transaction to record the transaction or increment a counter in some other table. 

    Art

    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------