Sysprofile question
IDS 9.4 on AIX 5.2.
I'm trying to monitor some statistics for multiple instances, so I'm
pulling (among other things) a bunch of values from sysprofiles. I have
a couple of servers that are very busy, and the value in the bufreads
row keeps rolling over. Is there any way to tell how many times that has
occurred, so I can compensate? Is there a better way to pull this
information?
For instance, `onstat -p` tells me I have 6572527610 buffer reads, while
sysprofiles at (about) the same time says -2019163235 (and is increasing
toward zero), so somehow the onstat is figuring this out, but my script
keeps pulling nonsensical values.
Thanks.
DC
In 9.4+ the values column in sysshmhdr (the pseudo-table underlying the
sysprofile VIEW) is an INT8. If you are fetching it into an int that will give
you incorrect results.
Art S. Kagel
----- Original Message -----
From: Doug Conrey <ids@iiug.org>
At: 3/28 10:56:23
IDS 9.4 on AIX 5.2.
I'm trying to monitor some statistics for multiple instances, so I'm
pulling (among other things) a bunch of values from sysprofiles. I have
a couple of servers that are very busy, and the value in the bufreads
row keeps rolling over. Is there any way to tell how many times that has
occurred, so I can compensate? Is there a better way to pull this
information?
For instance, `onstat -p` tells me I have 6572527610 buffer reads, while
sysprofiles at (about) the same time says -2019163235 (and is increasing
toward zero), so somehow the onstat is figuring this out, but my script
keeps pulling nonsensical values.
Thanks.
DC
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
ART
> KAGEL, BLOOMBERG/ 731 LEXIN
> Sent: Wednesday, March 28, 2007 9:08 AM
> To: ids@iiug.org
> Subject: Re: Sysprofile question [8747]
>
> In 9.4+ the values column in sysshmhdr (the pseudo-table underlying
the
> sysprofile VIEW) is an INT8. If you are fetching it into an int that
will
> give
> you incorrect results.
>
> Art S. Kagel
Hmm. I'm looking in the sysmaster.sql file and I see:
create table sysshmhdr { Internal Use Only}
(
number integer, { unique identifier for element
}
name char(16), { name of rhead_t element
}
value integer { value of rhead_t element
}
);
Our 10.0 instances do declare it as an int8, but this doesn't (I've
checked FC5 and FC8). Is there another workaround that anybody knows
about?
DC