Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
15 replies Latest Post - ‏2012-10-04T08:52:23Z by UteBaumbach
jmueller
jmueller
26 Posts
ACCEPTED ANSWER

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
    ACCEPTED ANSWER

    Re: Alerting

    ‏2012-03-13T14:45:58Z  in response to jmueller
    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.
    • jmueller
      jmueller
      26 Posts
      ACCEPTED ANSWER

      Re: Alerting

      ‏2012-03-13T15:11:24Z  in response to JoannaJanusz
      Hi Johanna,

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

      Best regards,
      Joachim
  • UteBaumbach
    UteBaumbach
    55 Posts
    ACCEPTED ANSWER

    Re: Alerting

    ‏2012-03-13T15:05:46Z  in response to jmueller
    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
      ACCEPTED ANSWER

      Re: Alerting

      ‏2012-03-13T15:14:17Z  in response to UteBaumbach
      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
    ACCEPTED ANSWER

    Re: Alerting

    ‏2012-03-13T17:08:51Z  in response to jmueller
    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
      ACCEPTED ANSWER

      Re: Alerting

      ‏2012-04-16T08:05:21Z  in response to GaryWalters
      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
        ACCEPTED ANSWER

        Re: Alerting

        ‏2012-04-16T19:29:49Z  in response to jmueller
        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
          ACCEPTED ANSWER

          Re: Alerting

          ‏2012-05-04T07:32:45Z  in response to GaryWalters
          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
            ACCEPTED ANSWER

            Re: Alerting

            ‏2012-05-04T14:40:44Z  in response to jmueller
            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
            ACCEPTED ANSWER

            Re: Alerting

            ‏2012-05-04T18:36:32Z  in response to jmueller
            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
              ACCEPTED ANSWER

              Re: Alerting

              ‏2012-05-07T08:39:16Z  in response to GaryWalters
              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
                ACCEPTED ANSWER

                Re: Alerting

                ‏2012-05-07T19:00:06Z  in response to jmueller
                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
                  ACCEPTED ANSWER

                  Re: Alerting

                  ‏2012-05-07T19:05:29Z  in response to GaryWalters
                  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
                    ACCEPTED ANSWER

                    Re: Alerting

                    ‏2012-06-14T21:40:36Z  in response to jmueller
                    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
    ACCEPTED ANSWER

    Re: Alerting

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

    Regards, Ute Baumbach