ALARMPROGRAM: Event Alarms Filtering?
A user on IDS 11.70 wanted to suppress ALARMPROGRAM notifications (severity 3 e-mails/incidents) raised when he deliberately stops Enterprise Replication during nightly dbexport runs, without editing the alarm script. Suggestions: have the export script touch a flag file that the ALARMPROGRAM checks (Art Kagel), temporarily reset ALARMPROGRAM to /dev/null with onmode -wm and restore it afterwards, check the ALRM_ALL_EVENTS onconfig setting (Alexandre Marini), and Madison Pruet noted ER alarms can be disabled individually via an onconfig parameter. The poster accepted these as a usable workaround; others questioned using dbexport instead of ontape/onbar.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello,
IDS 11.70
I need to find out if there is a way to force ALARMPROGRAM not to trigger
itself whenever certain types of events happen.
For example, I am making dbexport backups of all dbs during night, and I
need to temporarily stop ER. This event is with type WARNING and color
YELLOW, resulting in severity 3. My ALARMPROGRAM is set to PAGERADMIN=3,
thus I receive e-mail and an incident is being generated in a console.
But I want somehow to tell ALARMPROGRAM not to fire during the time
dbexport is being run. Afterwards, when replication is re-enabled, I want
again to monitor for cdr stop events as expected.
Do you have some idea without modifying the ALARMPROGRAM script?
Thanks!
BR,
Lyubomir Grigorov
--001a1142a3eee232c005234174d8
Touch a file in your export script and check for the file at the top of the
ALARMPROGRAM script or at the cases that you want to disable. When the
export script ends delete the file.
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, Oct 29, 2015 at 1:15 PM, Lyubomir Grigorov <lgrigorlu1@gmail.com>
wrote:
> Hello,
>
> IDS 11.70
>
> I need to find out if there is a way to force ALARMPROGRAM not to trigger
> itself whenever certain types of events happen.
>
> For example, I am making dbexport backups of all dbs during night, and I
> need to temporarily stop ER. This event is with type WARNING and color
> YELLOW, resulting in severity 3. My ALARMPROGRAM is set to PAGERADMIN=3,
> thus I receive e-mail and an incident is being generated in a console.
>
> But I want somehow to tell ALARMPROGRAM not to fire during the time
> dbexport is being run. Afterwards, when replication is re-enabled, I want
> again to monitor for cdr stop events as expected.
>
> Do you have some idea without modifying the ALARMPROGRAM script?
>
> Thanks!
>
> BR,
> Lyubomir Grigorov
>
> --001a1142a3eee232c005234174d8
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--047d7bd911a8d5166805234186f0
Hello,
First thing you should be aware of: dbexport are not made for backup purposes.
If you want to do manual backups, the most indicated way is through ontape or
onbar programs.
You can try to change ALARMPROGRAM while the engine is running, through
"onmode -wm" command.
Set it to /dev/null, I think it should work.
Don't forget to get it back to the original value after your dbexport is
finished.
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
IBM Information Management Informix Technical Professional
IBM Certified Developer - Informix Genero
BRIUG website administrator
Informix independent consultant
> To: ids@iiug.org
> From: lgrigorlu1@gmail.com
> Subject: ALARMPROGRAM: Event Alarms Filtering? [35969]
> Date: Thu, 29 Oct 2015 13:15:35 -0400
>
> Hello,
>
> IDS 11.70
>
> I need to find out if there is a way to force ALARMPROGRAM not to trigger
> itself whenever certain types of events happen.
>
> For example, I am making dbexport backups of all dbs during night, and I
> need to temporarily stop ER. This event is with type WARNING and color
> YELLOW, resulting in severity 3. My ALARMPROGRAM is set to PAGERADMIN=3,
> thus I receive e-mail and an incident is being generated in a console.
>
> But I want somehow to tell ALARMPROGRAM not to fire during the time
> dbexport is being run. Afterwards, when replication is re-enabled, I want
> again to monitor for cdr stop events as expected.
>
> Do you have some idea without modifying the ALARMPROGRAM script?
>
> Thanks!
>
> BR,
> Lyubomir Grigorov
>
> --001a1142a3eee232c005234174d8
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Another thing, if you really need to run dbexport, check the value of your
ALRM_ALL_EVENTS onconfig variable.
http://www-01.ibm.com/support/knowledgecenter/SSGU8G_11.70.0/com.ibm.adref.doc/i
ds_adr_0022.htm?lang=en-us
Best regards.
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
IBM Information Management Informix Technical Professional
IBM Certified Developer - Informix Genero
BRIUG website administrator
Informix independent consultant
From: alexandre@briug.org
To: ids@iiug.org
Subject: RE: ALARMPROGRAM: Event Alarms Filtering? [35969]
Date: Thu, 29 Oct 2015 15:41:23 -0200
Hello,
First thing you should be aware of: dbexport are not made for backup purposes.
If you want to do manual backups, the most indicated way is through ontape or
onbar programs.
You can try to change ALARMPROGRAM while the engine is running, through
"onmode -wm" command.
Set it to /dev/null, I think it should work.
Don't forget to get it back to the original value after your dbexport is
finished.
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
IBM Information Management Informix Technical Professional
IBM Certified Developer - Informix Genero
BRIUG website administrator
Informix independent consultant
> To: ids@iiug.org
> From: lgrigorlu1@gmail.com
> Subject: ALARMPROGRAM: Event Alarms Filtering? [35969]
> Date: Thu, 29 Oct 2015 13:15:35 -0400
>
> Hello,
>
> IDS 11.70
>
> I need to find out if there is a way to force ALARMPROGRAM not to trigger
> itself whenever certain types of events happen.
>
> For example, I am making dbexport backups of all dbs during night, and I
> need to temporarily stop ER. This event is with type WARNING and color
> YELLOW, resulting in severity 3. My ALARMPROGRAM is set to PAGERADMIN=3,
> thus I receive e-mail and an incident is being generated in a console.
>
> But I want somehow to tell ALARMPROGRAM not to fire during the time
> dbexport is being run. Afterwards, when replication is re-enabled, I want
> again to monitor for cdr stop events as expected.
>
> Do you have some idea without modifying the ALARMPROGRAM script?
>
> Thanks!
>
> BR,
> Lyubomir Grigorov
>
> --001a1142a3eee232c005234174d8
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Alexandre:
Many sites use dbexport for "safety" backups that they can use for
restoring a few records that might be fumble fingered.
BTW: If someone needs to do a dbexport for this purpose without the locking
problems you can use my dbexport replacement utility myexport!
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, Oct 29, 2015 at 1:41 PM, Alexandre Marini <alexandre@briug.org>
wrote:
> Hello,
> First thing you should be aware of: dbexport are not made for backup
> purposes.
> If you want to do manual backups, the most indicated way is through ontape
> or
> onbar programs.
>
> You can try to change ALARMPROGRAM while the engine is running, through
> "onmode -wm" command.
> Set it to /dev/null, I think it should work.
> Don't forget to get it back to the original value after your dbexport is
> finished.
>
> Alexandre Marini
> IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
>
> IBM Information Management Informix Technical Professional
>
> IBM Certified Developer - Informix Genero
> BRIUG website administrator
> Informix independent consultant
>
> > To: ids@iiug.org
> > From: lgrigorlu1@gmail.com
> > Subject: ALARMPROGRAM: Event Alarms Filtering? [35969]
> > Date: Thu, 29 Oct 2015 13:15:35 -0400
> >
> > Hello,
> >
> > IDS 11.70
> >
> > I need to find out if there is a way to force ALARMPROGRAM not to trigger
> > itself whenever certain types of events happen.
> >
> > For example, I am making dbexport backups of all dbs during night, and I
> > need to temporarily stop ER. This event is with type WARNING and color
> > YELLOW, resulting in severity 3. My ALARMPROGRAM is set to PAGERADMIN=3,
> > thus I receive e-mail and an incident is being generated in a console.
> >
> > But I want somehow to tell ALARMPROGRAM not to fire during the time
> > dbexport is being run. Afterwards, when replication is re-enabled, I want
> > again to monitor for cdr stop events as expected.
> >
> > Do you have some idea without modifying the ALARMPROGRAM script?
> >
> > Thanks!
> >
> > BR,
> > Lyubomir Grigorov
> >
> > --001a1142a3eee232c005234174d8
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a1142d85eb397d905234268b2
Ok, Art. But as an Informix fan, I always appreciate our uptime capacities...
LoL
Thanks.
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
IBM Information Management Informix Technical Professional
IBM Certified Developer - Informix Genero
BRIUG website administrator
Informix independent consultant
> To: ids@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: ALARMPROGRAM: Event Alarms Filtering? [35973]
> Date: Thu, 29 Oct 2015 14:23:38 -0400
>
> Alexandre:
>
> Many sites use dbexport for "safety" backups that they can use for
> restoring a few records that might be fumble fingered.
>
> BTW: If someone needs to do a dbexport for this purpose without the locking
> problems you can use my dbexport replacement utility myexport!
>
> 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, Oct 29, 2015 at 1:41 PM, Alexandre Marini <alexandre@briug.org>
> wrote:
>
> > Hello,
> > First thing you should be aware of: dbexport are not made for backup
> > purposes.
> > If you want to do manual backups, the most indicated way is through ontape
> > or
> > onbar programs.
> >
> > You can try to change ALARMPROGRAM while the engine is running, through
> > "onmode -wm" command.
> > Set it to /dev/null, I think it should work.
> > Don't forget to get it back to the original value after your dbexport is
> > finished.
> >
> > Alexandre Marini
> > IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
> >
> > IBM Information Management Informix Technical Professional
> >
> > IBM Certified Developer - Informix Genero
> > BRIUG website administrator
> > Informix independent consultant
> >
> > > To: ids@iiug.org
> > > From: lgrigorlu1@gmail.com
> > > Subject: ALARMPROGRAM: Event Alarms Filtering? [35969]
> > > Date: Thu, 29 Oct 2015 13:15:35 -0400
> > >
> > > Hello,
> > >
> > > IDS 11.70
> > >
> > > I need to find out if there is a way to force ALARMPROGRAM not to trigger
> > > itself whenever certain types of events happen.
> > >
> > > For example, I am making dbexport backups of all dbs during night, and I
> > > need to temporarily stop ER. This event is with type WARNING and color
> > > YELLOW, resulting in severity 3. My ALARMPROGRAM is set to PAGERADMIN=3,
> > > thus I receive e-mail and an incident is being generated in a console.
> > >
> > > But I want somehow to tell ALARMPROGRAM not to fire during the time
> > > dbexport is being run. Afterwards, when replication is re-enabled, I want
> > > again to monitor for cdr stop events as expected.
> > >
> > > Do you have some idea without modifying the ALARMPROGRAM script?
> > >
> > > Thanks!
> > >
> > > BR,
> > > Lyubomir Grigorov
> > >
> > > --001a1142a3eee232c005234174d8
> > >
> > >
> > >
> >
> >
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001a1142d85eb397d905234268b2
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
As do I!
Art
On Oct 29, 2015 11:52, "Alexandre Marini" <alexandre@briug.org> wrote:
> Ok, Art. But as an Informix fan, I always appreciate our uptime
> capacities...
> LoL
>
> Thanks.
>
> Alexandre Marini
> IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
>
> IBM Information Management Informix Technical Professional
>
> IBM Certified Developer - Informix Genero
> BRIUG website administrator
> Informix independent consultant
>
> > To: ids@iiug.org
> > From: art.kagel@gmail.com
> > Subject: Re: ALARMPROGRAM: Event Alarms Filtering? [35973]
> > Date: Thu, 29 Oct 2015 14:23:38 -0400
> >
> > Alexandre:
> >
> > Many sites use dbexport for "safety" backups that they can use for
> > restoring a few records that might be fumble fingered.
> >
> > BTW: If someone needs to do a dbexport for this purpose without the
> locking
> > problems you can use my dbexport replacement utility myexport!
> >
> > 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, Oct 29, 2015 at 1:41 PM, Alexandre Marini <alexandre@briug.org>
> > wrote:
> >
> > > Hello,
> > > First thing you should be aware of: dbexport are not made for backup
> > > purposes.
> > > If you want to do manual backups, the most indicated way is through
> ontape> > > or
> > > onbar programs.
> > >
> > > You can try to change ALARMPROGRAM while the engine is running, through
> > > "onmode -wm" command.
> > > Set it to /dev/null, I think it should work.
> > > Don't forget to get it back to the original value after your dbexport
> is
> > > finished.
> > >
> > > Alexandre Marini
> > > IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
> > >
> > > IBM Information Management Informix Technical Professional
> > >
> > > IBM Certified Developer - Informix Genero
> > > BRIUG website administrator
> > > Informix independent consultant
> > >
> > > > To: ids@iiug.org
> > > > From: lgrigorlu1@gmail.com
> > > > Subject: ALARMPROGRAM: Event Alarms Filtering? [35969]
> > > > Date: Thu, 29 Oct 2015 13:15:35 -0400
> > > >
> > > > Hello,
> > > >
> > > > IDS 11.70
> > > >
> > > > I need to find out if there is a way to force ALARMPROGRAM not to
> trigger
> > > > itself whenever certain types of events happen.
> > > >
> > > > For example, I am making dbexport backups of all dbs during night,
> and I
> > > > need to temporarily stop ER. This event is with type WARNING and
> color
> > > > YELLOW, resulting in severity 3. My ALARMPROGRAM is set to
> PAGERADMIN=3,
> > > > thus I receive e-mail and an incident is being generated in a
> console.
> > > >
> > > > But I want somehow to tell ALARMPROGRAM not to fire during the time
> > > > dbexport is being run. Afterwards, when replication is re-enabled, I
> want
> > > > again to monitor for cdr stop events as expected.
> > > >
> > > > Do you have some idea without modifying the ALARMPROGRAM script?
> > > >
> > > > Thanks!
> > > >
> > > > BR,
> > > > Lyubomir Grigorov
> > > >
> > > > --001a1142a3eee232c005234174d8
> > > >
> > > >
> > > >
> > >
> > >
> >
>
>
*******************************************************************************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > >
> > >
> > >
> > >
> >
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --001a1142d85eb397d905234268b2
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--047d7bd911a8f7bcb605234366f1
Thank you for your comments Art and Alexandre! It will do the trick as a
workaround.
I am also not the biggest fan of exports, but we use them a lot for cloning
to another sites for example, or by the devs for testing and for what Art
mentioned.
onbar is our primary backup method.
2015-10-29 21:34 GMT+02:00 Art Kagel <art.kagel@gmail.com>:
> As do I!
>
> Art
> On Oct 29, 2015 11:52, "Alexandre Marini" <alexandre@briug.org> wrote:
>
> > Ok, Art. But as an Informix fan, I always appreciate our uptime
> > capacities...
> > LoL
> >
> > Thanks.
> >
> > Alexandre Marini
> > IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
> >
> > IBM Information Management Informix Technical Professional
> >
> > IBM Certified Developer - Informix Genero
> > BRIUG website administrator
> > Informix independent consultant
> >
> > > To: ids@iiug.org
> > > From: art.kagel@gmail.com
> > > Subject: Re: ALARMPROGRAM: Event Alarms Filtering? [35973]
> > > Date: Thu, 29 Oct 2015 14:23:38 -0400
> > >
> > > Alexandre:
> > >
> > > Many sites use dbexport for "safety" backups that they can use for
> > > restoring a few records that might be fumble fingered.
> > >
> > > BTW: If someone needs to do a dbexport for this purpose without the
> > locking
> > > problems you can use my dbexport replacement utility myexport!
> > >
> > > 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, Oct 29, 2015 at 1:41 PM, Alexandre Marini <alexandre@briug.org
> >
> > > wrote:
> > >
> > > > Hello,
> > > > First thing you should be aware of: dbexport are not made for backup
> > > > purposes.
> > > > If you want to do manual backups, the most indicated way is through
> > ontape> > > > or
> > > > onbar programs.
> > > >
> > > > You can try to change ALARMPROGRAM while the engine is running,
> through
> > > > "onmode -wm" command.
> > > > Set it to /dev/null, I think it should work.
> > > > Don't forget to get it back to the original value after your dbexport
> > is
> > > > finished.
> > > >
> > > > Alexandre Marini
> > > > IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
> > > >
> > > > IBM Information Management Informix Technical Professional
> > > >
> > > > IBM Certified Developer - Informix Genero
> > > > BRIUG website administrator
> > > > Informix independent consultant
> > > >
> > > > > To: ids@iiug.org
> > > > > From: lgrigorlu1@gmail.com
> > > > > Subject: ALARMPROGRAM: Event Alarms Filtering? [35969]
> > > > > Date: Thu, 29 Oct 2015 13:15:35 -0400
> > > > >
> > > > > Hello,
> > > > >
> > > > > IDS 11.70
> > > > >
> > > > > I need to find out if there is a way to force ALARMPROGRAM not to
> > trigger
> > > > > itself whenever certain types of events happen.
> > > > >
> > > > > For example, I am making dbexport backups of all dbs during night,
> > and I
> > > > > need to temporarily stop ER. This event is with type WARNING and
> > color
> > > > > YELLOW, resulting in severity 3. My ALARMPROGRAM is set to
> > PAGERADMIN=3,
> > > > > thus I receive e-mail and an incident is being generated in a
> > console.
> > > > >
> > > > > But I want somehow to tell ALARMPROGRAM not to fire during the time
> > > > > dbexport is being run. Afterwards, when replication is re-enabled,
> I
> > want
> > > > > again to monitor for cdr stop events as expected.
> > > > >
> > > > > Do you have some idea without modifying the ALARMPROGRAM script?
> > > > >
> > > > > Thanks!
> > > > >
> > > > > BR,
> > > > > Lyubomir Grigorov
> > > > >
> > > > > --001a1142a3eee232c005234174d8
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> >
> >
>
>
*******************************************************************************
> > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > > >
> > > >
> > > >
> > > >
> > > >
> > >
> >
> >
>
>
*******************************************************************************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > >
> > > --001a1142d85eb397d905234268b2
> > >
> > >
> > >
> >
> >
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --047d7bd911a8f7bcb605234366f1
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a11430b6a1c28c9052343d16e
The ER alarms can be indivually disabled with an onconfig parameter.
Sent from Yahoo Mail on Android
From:"Lyubomir Grigorov" <lgrigorlu1@gmail.com>
Date:Thu, Oct 29, 2015 at 12:16 PM
Subject:ALARMPROGRAM: Event Alarms Filtering? [35969]
Hello,
IDS 11.70
I need to find out if there is a way to force ALARMPROGRAM not to trigger
itself whenever certain types of events happen.
For example, I am making dbexport backups of all dbs during night, and I
need to temporarily stop ER. This event is with type WARNING and color
YELLOW, resulting in severity 3. My ALARMPROGRAM is set to PAGERADMIN=3,
thus I receive e-mail and an incident is being generated in a console.
But I want somehow to tell ALARMPROGRAM not to fire during the time
dbexport is being run. Afterwards, when replication is re-enabled, I want
again to monitor for cdr stop events as expected.
Do you have some idea without modifying the ALARMPROGRAM script?
Thanks!
BR,
Lyubomir Grigorov
--001a1142a3eee232c005234174d8
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
hello
must say I an surprised to read this.
For example, I am making dbexport backups of all dbs during night, and I
need to temporarily stop ER
I find using ontape is best way to move dbs around much easier and faster then
using export/import. I guess depends on how big you dbs are.
Also suspending ER while doing export is kinda risky I would have thought.