IC5Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Topic
  • 15 replies
  • Latest Post - ‏2012-10-04T08:52:23Z by UteBaumbach
jmueller
jmueller
26 Posts

Pinned topic Alerting

‏2012-03-13T13:22:30Z |
Hello OPM Forum,

After stopping a database I receive every minute a reminder Alert(e-mail) from OPM 5.1.
Attach you will find the alerting configuration for the event.

Perhaps somebody has the same problem.

Found nothing about this error in the forum nor in the on OPM support.

Best regards
Joachim
Updated on 2012-10-04T08:52:23Z at 2012-10-04T08:52:23Z by UteBaumbach
  • JoannaJanusz
    JoannaJanusz
    1 Post

    Re: Alerting

    ‏2012-03-13T14:45:58Z  
    Hi Joachim,

    if you don't want to receive such emails, you need to disable this alert notification using the checkbox which is visible in your screenshot under the "Severity: Warning or Critical" combo box. You can also delete the alert notification altogether if you do not wish to use it in the future.

    Best regards,
    Joanna Janusz, OPM team.
  • UteBaumbach
    UteBaumbach
    55 Posts

    Re: Alerting

    ‏2012-03-13T15:05:46Z  
    Hi Joachim,
    in the screenshot I see that you have no Reminder Interval set. Therefore you expect that no reminder email is sent, right ?
    We will check the behavior of the reminder email in the lab.
    Thanks.
    Regards
    Ute Baumbach
  • jmueller
    jmueller
    26 Posts

    Re: Alerting

    ‏2012-03-13T15:11:24Z  
    Hi Joachim,

    if you don't want to receive such emails, you need to disable this alert notification using the checkbox which is visible in your screenshot under the "Severity: Warning or Critical" combo box. You can also delete the alert notification altogether if you do not wish to use it in the future.

    Best regards,
    Joanna Janusz, OPM team.
    Hi Johanna,

    I want receive such email but not every minute. Only one is for acceptable.

    Best regards,
    Joachim
  • jmueller
    jmueller
    26 Posts

    Re: Alerting

    ‏2012-03-13T15:14:17Z  
    Hi Joachim,
    in the screenshot I see that you have no Reminder Interval set. Therefore you expect that no reminder email is sent, right ?
    We will check the behavior of the reminder email in the lab.
    Thanks.
    Regards
    Ute Baumbach
    Hi Ute,

    Thanks.

    After stopping and starting OPM, the error occur once again. But I believe, that is really new.
    Best regards,
    Joachim
  • GaryWalters
    GaryWalters
    6 Posts

    Re: Alerting

    ‏2012-03-13T17:08:51Z  
    Hi,

    I did some additional testing on this and found that if the initial alert notification had the Reminder Interval box checked and an Alert was generated, then a reminder email will continue to be sent even if the box is unchecked later on.

    Here are the steps:

    1. Enable notification on an Alert(in this case, Monitoring Status), be sure the Reminder Interval is checked.
    2. Deactivate the database or take the instance down, then restart.
    3. Once the Alert is generated, uncheck the Reminder Interval box.
    4. Repeat step 2, new Alerts will not generate a reminder email. The old Alert continues to do so every minute or so, even though the initial reminder time was 15 minutes.

    I will take action to get this fixed.

    Thanks,

    Gary
  • jmueller
    jmueller
    26 Posts

    Re: Alerting

    ‏2012-04-16T08:05:21Z  
    Hi,

    I did some additional testing on this and found that if the initial alert notification had the Reminder Interval box checked and an Alert was generated, then a reminder email will continue to be sent even if the box is unchecked later on.

    Here are the steps:

    1. Enable notification on an Alert(in this case, Monitoring Status), be sure the Reminder Interval is checked.
    2. Deactivate the database or take the instance down, then restart.
    3. Once the Alert is generated, uncheck the Reminder Interval box.
    4. Repeat step 2, new Alerts will not generate a reminder email. The old Alert continues to do so every minute or so, even though the initial reminder time was 15 minutes.

    I will take action to get this fixed.

    Thanks,

    Gary
    Hi Gary,

    is this problem solved in the interim fix or the coming 5.1.1 end of April.

    Best regards
    Joachim
  • GaryWalters
    GaryWalters
    6 Posts

    Re: Alerting

    ‏2012-04-16T19:29:49Z  
    • jmueller
    • ‏2012-04-16T08:05:21Z
    Hi Gary,

    is this problem solved in the interim fix or the coming 5.1.1 end of April.

    Best regards
    Joachim
    Hi Joachim,

    I apologize for not getting back to you sooner, I tested with the latest 5.1.1 build and was not able to reproduce the problem so you will be fine with that version.

    Let me know if you run into any further issues.

    Thanks,

    Gary
  • jmueller
    jmueller
    26 Posts

    Re: Alerting

    ‏2012-05-04T07:32:45Z  
    Hi Joachim,

    I apologize for not getting back to you sooner, I tested with the latest 5.1.1 build and was not able to reproduce the problem so you will be fine with that version.

    Let me know if you run into any further issues.

    Thanks,

    Gary
    Hello Gary,

    Upgrading the OPM to 5.1.1 the error occured again. No success.

    After configuring a new database for alerting and stopping the database
    each minute I got an email.

    You can see both in the attached files.

    Best regards
    Joachim

    Environment:
    db2pmp@r2l04
    [/db2/db2pmp]> pmlevel
    ==============================================================================
    IBM InfoSphere Optim Performance Manager
    ==============================================================================
    InfoSphere Optim Performance Manager Server for DB2 for Linux, UNIX and Windows
    Version 5.1.1.0.4068, code levels: opmc-5.1.1.0.4068,common-5.1.1.0.4068,pdq-3.110.103
    ==============================================================================

    db2pmp@r2l04
    [/db2/db2pmp]> db2level
    DB21085I Instance "db2pmp" uses "64" bits and DB2 code release "SQL09075" with
    level identifier "08060107".
    Informational tokens are "DB2 v9.7.0.5", "s111017", "IP23285", and Fix Pack
    "5".
    Product is installed at "/opt/IBM/OPM/V9.7".

    db2pmp@r2l04
    [/db2/db2pmp]> oslevel -s
    7100-01-02-1150
  • GaryWalters
    GaryWalters
    6 Posts

    Re: Alerting

    ‏2012-05-04T14:40:44Z  
    • jmueller
    • ‏2012-05-04T07:32:45Z
    Hello Gary,

    Upgrading the OPM to 5.1.1 the error occured again. No success.

    After configuring a new database for alerting and stopping the database
    each minute I got an email.

    You can see both in the attached files.

    Best regards
    Joachim

    Environment:
    db2pmp@r2l04
    [/db2/db2pmp]> pmlevel
    ==============================================================================
    IBM InfoSphere Optim Performance Manager
    ==============================================================================
    InfoSphere Optim Performance Manager Server for DB2 for Linux, UNIX and Windows
    Version 5.1.1.0.4068, code levels: opmc-5.1.1.0.4068,common-5.1.1.0.4068,pdq-3.110.103
    ==============================================================================

    db2pmp@r2l04
    [/db2/db2pmp]> db2level
    DB21085I Instance "db2pmp" uses "64" bits and DB2 code release "SQL09075" with
    level identifier "08060107".
    Informational tokens are "DB2 v9.7.0.5", "s111017", "IP23285", and Fix Pack
    "5".
    Product is installed at "/opt/IBM/OPM/V9.7".

    db2pmp@r2l04
    [/db2/db2pmp]> oslevel -s
    7100-01-02-1150
    Hi Joachim,

    I will go through the test scenario again, just to make sure I am not missing any steps.

    Thanks,

    Gary
  • GaryWalters
    GaryWalters
    6 Posts

    Re: Alerting

    ‏2012-05-04T18:36:32Z  
    • jmueller
    • ‏2012-05-04T07:32:45Z
    Hello Gary,

    Upgrading the OPM to 5.1.1 the error occured again. No success.

    After configuring a new database for alerting and stopping the database
    each minute I got an email.

    You can see both in the attached files.

    Best regards
    Joachim

    Environment:
    db2pmp@r2l04
    [/db2/db2pmp]> pmlevel
    ==============================================================================
    IBM InfoSphere Optim Performance Manager
    ==============================================================================
    InfoSphere Optim Performance Manager Server for DB2 for Linux, UNIX and Windows
    Version 5.1.1.0.4068, code levels: opmc-5.1.1.0.4068,common-5.1.1.0.4068,pdq-3.110.103
    ==============================================================================

    db2pmp@r2l04
    [/db2/db2pmp]> db2level
    DB21085I Instance "db2pmp" uses "64" bits and DB2 code release "SQL09075" with
    level identifier "08060107".
    Informational tokens are "DB2 v9.7.0.5", "s111017", "IP23285", and Fix Pack
    "5".
    Product is installed at "/opt/IBM/OPM/V9.7".

    db2pmp@r2l04
    [/db2/db2pmp]> oslevel -s
    7100-01-02-1150
    Hi Joachim,

    I did the same basic steps as before, and the emails alerts stopped from my machine:

    Add Alert notification for Database Availability, activate the reminder for 1 minute. After a few emails, uncheck the reminder.

    Can you enable tracing for the AlertNotificationLogger and send the resulting file?

    Open -> Product Setup -> Services, then click on AlertNotificationLogger and Configure. Set the Log level to Debug, leave the other options the same. This will populate the log file in /opt/IBM/OPM/logs/AlertNotificationLogger.0. This log can also be viewed in Open -> Product Setup -> Logs.

    Thanks,

    Gary
  • jmueller
    jmueller
    26 Posts

    Re: Alerting

    ‏2012-05-07T08:39:16Z  
    Hi Joachim,

    I did the same basic steps as before, and the emails alerts stopped from my machine:

    Add Alert notification for Database Availability, activate the reminder for 1 minute. After a few emails, uncheck the reminder.

    Can you enable tracing for the AlertNotificationLogger and send the resulting file?

    Open -> Product Setup -> Services, then click on AlertNotificationLogger and Configure. Set the Log level to Debug, leave the other options the same. This will populate the log file in /opt/IBM/OPM/logs/AlertNotificationLogger.0. This log can also be viewed in Open -> Product Setup -> Logs.

    Thanks,

    Gary
    Hi Gary,

    First thanks for your help.

    What I'm doing wrong?

    Add Alert "New Alert Notification" choose an "alert type" add an email an uncheck "Reminder interval" and last OK.
    These are the steps. After stopping the database each minute an email pops up.

    What are the steps to get one email for the alert an one email when the alert is closed?

    Setting the AlertNotificationLogger to trace:

    AlertNotificationLogger (275) May 7, 2012 10:24:25 AM TRACE Alert notification email was sent to jmueller@douglas-informatik.de for alert #103588 at 5/7/12 10:24 AM
    AlertNotificationLogger (275) May 7, 2012 10:25:25 AM TRACE Alert notification email was sent to jmueller@douglas-informatik.de for alert #103588 at 5/7/12 10:25 AM
    AlertNotificationLogger (344) May 7, 2012 10:26:24 AM TRACE Alert notification email was sent to jmueller@douglas-informatik.de for alert #103588 at 5/7/12 10:26 AM

    Best regards
    Joachim
  • GaryWalters
    GaryWalters
    6 Posts

    Re: Alerting

    ‏2012-05-07T19:00:06Z  
    • jmueller
    • ‏2012-05-07T08:39:16Z
    Hi Gary,

    First thanks for your help.

    What I'm doing wrong?

    Add Alert "New Alert Notification" choose an "alert type" add an email an uncheck "Reminder interval" and last OK.
    These are the steps. After stopping the database each minute an email pops up.

    What are the steps to get one email for the alert an one email when the alert is closed?

    Setting the AlertNotificationLogger to trace:

    AlertNotificationLogger (275) May 7, 2012 10:24:25 AM TRACE Alert notification email was sent to jmueller@douglas-informatik.de for alert #103588 at 5/7/12 10:24 AM
    AlertNotificationLogger (275) May 7, 2012 10:25:25 AM TRACE Alert notification email was sent to jmueller@douglas-informatik.de for alert #103588 at 5/7/12 10:25 AM
    AlertNotificationLogger (344) May 7, 2012 10:26:24 AM TRACE Alert notification email was sent to jmueller@douglas-informatik.de for alert #103588 at 5/7/12 10:26 AM

    Best regards
    Joachim
    Hi Joachim,

    I am finally able to reproduce the problem reliably with these steps:

    1. Add Alert "New Alert Notification" choose "Database Availibility"
    2. Add an email address
    3. Uncheck "Reminder interval", do not change the interval time
    4. Check 'Send a notification when an alert is closed"
    5. Click OK.
    After stopping the database an email will be generated each minute.
    1. Now edit the notification and uncheck Enabled, the emails will stop.
    2. Edit again and check the Enabled button and they will start back up.

    As a workaround, delete the current notification and create a new one with the Reminder interval checked. When you get a reminder email, go back and uncheck it. This should stop the reminders, but will still produce an alert when the database cannot be reached.

    I will keep you posted on the progress of the fix(again!).

    Thanks,

    Gary
  • jmueller
    jmueller
    26 Posts

    Re: Alerting

    ‏2012-05-07T19:05:29Z  
    Hi Joachim,

    I am finally able to reproduce the problem reliably with these steps:

    1. Add Alert "New Alert Notification" choose "Database Availibility"
    2. Add an email address
    3. Uncheck "Reminder interval", do not change the interval time
    4. Check 'Send a notification when an alert is closed"
    5. Click OK.
    After stopping the database an email will be generated each minute.
    1. Now edit the notification and uncheck Enabled, the emails will stop.
    2. Edit again and check the Enabled button and they will start back up.

    As a workaround, delete the current notification and create a new one with the Reminder interval checked. When you get a reminder email, go back and uncheck it. This should stop the reminders, but will still produce an alert when the database cannot be reached.

    I will keep you posted on the progress of the fix(again!).

    Thanks,

    Gary
    Hi Gary,

    Thank you for the workaround. I will also wait for the coming fix.
    Once again thanks for your help.

    Regards,
    Joachim
  • GaryWalters
    GaryWalters
    6 Posts

    Re: Alerting

    ‏2012-06-14T21:40:36Z  
    • jmueller
    • ‏2012-05-07T19:05:29Z
    Hi Gary,

    Thank you for the workaround. I will also wait for the coming fix.
    Once again thanks for your help.

    Regards,
    Joachim
    Hi Joachim,

    I just tested the fix for this problem. It will be in the 5.1.1.1 release due out mid September, if all goes well.

    Thanks!

    Gary
  • UteBaumbach
    UteBaumbach
    55 Posts

    Re: Alerting

    ‏2012-10-04T08:52:23Z  
    Hi, FYI, this is the confirmation that the problem is fixed in OPM V5.1.1.1

    Regards, Ute Baumbach