Determining "onstat -z"

Posted in 2004

Summary

Fred Prose asked how to detect programmatically whether onstat -z had been run, since resets skew delta-based I/O logging. Eric Herber pointed to sysmaster:sysshmvals.sh_pfclrtime. Jonathan Leffler asked about controlling who may run onstat -z; Herber agreed that would be a good future feature and mentioned DB2's per-connection monitor reset.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: General Discussion

Fred Prose — 25 Feb 2004 08:31:24 -0800 — source: Usenet: comp.databases.informix

Is there any way to programmatically determine if a "onstat -z" has been issued? We run some analysis tools/scripts that log deltas for things like IO and resetting the counts really skews the output. Thanks, Fred Prose

↪ replying to Fred Prose

Eric Herber — Wed, 25 Feb 2004 19:24:22 +0100 — source: Usenet: comp.databases.informix

Fred Prose wrote: > Is there any way to programmatically determine if a "onstat -z" has > been issued? We run some analysis tools/scripts that log deltas for > things like IO and resetting the counts really skews the output. > > > Thanks, > Fred Prose Check the following column: sysmaster:sysshmvals.sh_pfclrtime HTH. Best regards Eric -- IT-Consulting Herber *********************************************** Download the IFMX Database-Monitor for free at: http://www.herber-consulting.de/BusyBee ***********************************************

↪ replying to Eric Herber

Jonathan Leffler — Thu, 26 Feb 2004 04:22:52 GMT — source: Usenet: comp.databases.informix

Eric Herber wrote: > Fred Prose wrote: >>Is there any way to programmatically determine if a "onstat -z" has >>been issued? We run some analysis tools/scripts that log deltas for >>things like IO and resetting the counts really skews the output. > > Check the following column: > > sysmaster:sysshmvals.sh_pfclrtime And provide some mechanism to control who can issue 'onstat -z'? -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

↪ replying to Jonathan Leffler

Eric Herber — Thu, 26 Feb 2004 10:24:43 +0100 — source: Usenet: comp.databases.informix

Jonathan Leffler wrote: > Eric Herber wrote: >> Fred Prose wrote: >>>Is there any way to programmatically determine if a "onstat -z" has >>>been issued? We run some analysis tools/scripts that log deltas for >>>things like IO and resetting the counts really skews the output. >> >> Check the following column: >> >> sysmaster:sysshmvals.sh_pfclrtime > > And provide some mechanism to control who can issue 'onstat -z'? > Yes, that would be nice feature for a future informix release. The fact that everybody is able to execute 'onstat -z' is a problem if you try to monitor the instance and sampling data from the sysmaster database. Also the DB2 approach where you can reset the current counters (db2 reset monitor...) and it only affects your own connection (because each connection has a private view of this monitor data) is helpful. However this might be difficult to implement for the sysmaster interface. Best regards Eric -- IT-Consulting Herber *********************************************** Download the IFMX Database-Monitor for free at: http://www.herber-consulting.de/BusyBee ***********************************************

Related threads

Glossary

onstat