Determining "onstat -z"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fred Prose - 25 Feb 2004 16:31 GMT

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

Reply to this Message

Eric Herber - 25 Feb 2004 18:24 GMT

> 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

Signature

IT-Consulting Herber
***********************************************
Download the IFMX Database-Monitor for free at:
http://www.herber-consulting.de/BusyBee
***********************************************

Reply to this Message

Jonathan Leffler - 26 Feb 2004 04:22 GMT

>>Is there any way to programmatically determine if a "onstat -z" has
>>been issued? We run some analysis tools/scripts that log deltas for
[quoted text clipped - 3 lines]
>
> sysmaster:sysshmvals.sh_pfclrtime

And provide some mechanism to control who can issue 'onstat -z'?

Signature

Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

Reply to this Message

Eric Herber - 26 Feb 2004 09:24 GMT

>>>Is there any way to programmatically determine if a "onstat -z" has
>>>been issued? We run some analysis tools/scripts that log deltas for
[quoted text clipped - 5 lines]
>
> 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

Signature

Reply to this Message

Ravi T - 25 Feb 2004 21:34 GMT

--0-155253167-1077744860=:48810
Content-Type: text/plain; charset=us-ascii

Yes, include in your program if the isreads and iswrites on syssessprof = 0. That means some one issued onstat -z.

Hope this helps.

Ravi Thero

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

---------------------------------
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
--0-155253167-1077744860=:48810
Content-Type: text/html; charset=us-ascii

<DIV>
<DIV>Yes, include in your program if the isreads and iswrites on syssessprof = 0.  That means some one issued onstat -z. </DIV>
<DIV> </DIV>
<DIV>Hope this helps.</DIV>
<DIV> </DIV>
<DIV>Ravi Thero <BR><BR><BR><B><I>Fred Prose <fprose@hotmail.com></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Is there any way to programmatically determine if a "onstat -z" has<BR>been issued? We run some analysis tools/scripts that log deltas for<BR>things like IO and resetting the counts really skews the output.<BR><BR><BR>Thanks,<BR>Fred Prose</BLOCKQUOTE></DIV><p><hr SIZE=1>
Do you Yahoo!?<br>
<a href="http://us.rd.yahoo.com/mailtag_us/*http://antispam.yahoo.com/tools?tool=1">Yahoo! Mail SpamGuard</a> - Read only the mail you want.</a>
--0-155253167-1077744860=:48810--
sending to informix-list

Reply to this Message