STORAGE_FULL_ALARM
The poster wanted advance warning of dbspaces filling up, noting that STORAGE_FULL_ALARM only seems to fire once space has run out, and asked whether it can alert at, say, 90% full. Clive Eisen said he gave up on that alarm and instead wrote a script parsing onstat -d. Art Kagel suggested taking the source of his dbsavail utility (in the utils2_ak package on the IIUG Software Repository, with newer betas at askdbmgt.com/my-utilities) and modifying it to alert on a chosen free-space threshold. The poster felt that was beyond his skill level, so no configuration of STORAGE_FULL_ALARM itself was given.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
We are trying to get some monitoring setup to let us know when diskspace is running out. I have been reading up on this STORAGE_FULL_ALARM. It looks to me like it alarms and sends a message to the message log once it is out of space. Is it possible to tell it to alarm when it is 90% out of space?
> On 11 Apr 2017, at 14:57, BENJI LONG <ruggedmouse@hotmail.com> wrote:
>
> We are trying to get some monitoring setup to let us know when diskspace is
> running out. I have been reading up on this STORAGE_FULL_ALARM.
I gave up trying to get that do what I wanted and wrote something to parse
onstat -d
Clive
No need to parse onstat -d output. You could take the code for my dbsavail
utility and modify it to send a message anytime a dbspace falls below 90%
free or 100,000 pages free or whatever rule you want. It's not hard, most
of the code is there.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Wed, Apr 12, 2017 at 8:01 PM, Clive Eisen <clive@serendipita.com> wrote:
> > On 11 Apr 2017, at 14:57, BENJI LONG <ruggedmouse@hotmail.com> wrote:
> >
> > We are trying to get some monitoring setup to let us know when diskspace
> is
> > running out. I have been reading up on this STORAGE_FULL_ALARM.
>
> I gave up trying to get that do what I wanted and wrote something to parse
> onstat -d>
> Clive
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a1147b198aaafd6054d0bc196
Hi Art, where is this dbavail utility?
Dbsavail is part of my utils2_ak package. Like my other utilities it is downloadable from the IIUG Software Repository (www.iiug.org/software). However, the latest Beta release is also available on my own website at: www.askdbmgt.com/my-utilities Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Apr 13, 2017 at 10:38 AM, BENJI LONG <ruggedmouse@hotmail.com> wrote: > Hi Art, where is this dbavail utility? > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --94eb2c11569615f078054d0d8ba8
Perfect, thanks Art
I think that is a bit above my knowledge.It looks to me like there are at least 10 of these which I'm guessing the latest is the most recent. I don't think I could set that up, but thanks anyhow.