Db2 On Premise and Cloud

 View Only
  • 1.  Event monitor

    Posted Fri April 22, 2022 08:15 AM
    Hello DMC Support Team,
    Are there any problems with the event monitor from DMC?

    I have a lot of event monitors in the output:

    select evmonname, event_mon_state(evmonname) event_mon_state, TARGET from syscat.eventmonitors;
    EVMONNAME EVENT_MON_STATE TARGET
    ------------------------------------ --------------- ------
    RTMON_EVMON_ACTIVITIES_1650622667102 0
    RTMON_EVMON_ACTIVITIES_1650622366643 0
    RTMON_EVMON_ACTIVITIES_1650622062057 0
    RTMON_EVMON_ACTIVITIES_1650621758637 0
    RTMON_EVMON_ACTIVITIES_1650594651799 0
    RTMON_EVMON_ACTIVITIES_1650594350707 0
    RTMON_EVMON_ACTIVITIES_1650594050088 0
    RTMON_EVMON_ACTIVITIES_1650593745830 0
    RTMON_EVMON_ACTIVITIES_1650589490148 0
    RTMON_EVMON_ACTIVITIES_1650588877174 0
    RTMON_EVMON_ACTIVITIES_1650588572470 0
    RTMON_EVMON_ACTIVITIES_1650587359268 0
    RTMON_EVMON_ACTIVITIES_1650566694469 0
    RTMON_EVMON_ACTIVITIES_1650566394116 0
    RTMON_EVMON_ACTIVITIES_1650566088550 0
    RTMON_EVMON_ACTIVITIES_1650564558380 0
    RTMON_EVMON_ACTIVITIES_1650551805554 0
    RTMON_EVMON_ACTIVITIES_1650551502429 0
    RTMON_EVMON_ACTIVITIES_1650550586303 0
    RTMON_EVMON_ACTIVITIES_1650549981115 0
    RTMON_EVMON_ACTIVITIES_1650540873414 0
    RTMON_EVMON_ACTIVITIES_1650540567896 0
    RTMON_EVMON_ACTIVITIES_1650540264542 0
    RTMON_EVMON_ACTIVITIES_1650539956375 0
    RTMON_EVMON_ACTIVITIES_1650499515640 0
    RTMON_EVMON_ACTIVITIES_1650499211915 0
    RTMON_EVMON_ACTIVITIES_1650498604753 0
    RTMON_EVMON_ACTIVITIES_1650498301699 0
    RTMON_EVMON_ACTIVITIES_1650626322546 0
    RTMON_EVMON_ACTIVITIES_1650625718445 0
    RTMON_EVMON_ACTIVITIES_1650625415764 0
    RTMON_EVMON_ACTIVITIES_1650624500341 0
    RTMON_EVMON_ACTIVITIES_1650612622728 0
    RTMON_EVMON_ACTIVITIES_1650612010545 0
    RTMON_EVMON_ACTIVITIES_1650611704494 0
    RTMON_EVMON_ACTIVITIES_1650611089446 0
    RTMON_EVMON_ACTIVITIES_1650599212642 0
    RTMON_EVMON_ACTIVITIES_1650598605076 0
    RTMON_EVMON_ACTIVITIES_1650598301769 0
    RTMON_EVMON_ACTIVITIES_1650597997785 0
    RTMON_EVMON_ACTIVITIES_1650571247788 0
    RTMON_EVMON_ACTIVITIES_1650570645569 0
    RTMON_EVMON_ACTIVITIES_1650570341076 0
    RTMON_EVMON_ACTIVITIES_1650570037204 0
    RTMON_EVMON_ACTIVITIES_1650560309420 0
    RTMON_EVMON_ACTIVITIES_1650559704499 0
    RTMON_EVMON_ACTIVITIES_1650559099606 0
    RTMON_EVMON_ACTIVITIES_1650558798842 0
    RTMON_EVMON_ACTIVITIES_1650544213911 0
    RTMON_EVMON_ACTIVITIES_1650543911725 0
    RTMON_EVMON_ACTIVITIES_1650543611629 0
    RTMON_EVMON_ACTIVITIES_1650543308952 0
    RTMON_EVMON_ACTIVITIES_1650532374037 0
    RTMON_EVMON_ACTIVITIES_1650531768227 0
    RTMON_EVMON_ACTIVITIES_1650531160282 0
    RTMON_EVMON_ACTIVITIES_1650530857399 0
    RTMON_EVMON_ACTIVITIES_1650521705097 0
    RTMON_EVMON_ACTIVITIES_1650521091921 0
    RTMON_EVMON_ACTIVITIES_1650520481614 0
    RTMON_EVMON_ACTIVITIES_1650519872727 0
    RTMON_EVMON_ACTIVITIES_1650509245531 0
    RTMON_EVMON_ACTIVITIES_1650508940385 0
    RTMON_EVMON_ACTIVITIES_1650508636371 0
    RTMON_EVMON_ACTIVITIES_1650508334631 0
    RTMON_EVMON_ACTIVITIES_1650504075173 0
    RTMON_EVMON_ACTIVITIES_1650503770832 0
    RTMON_EVMON_ACTIVITIES_1650503466574 0
    RTMON_EVMON_ACTIVITIES_1650502860848 0
    RTMON_EVMON_ACTIVITIES_1650497998876 0
    RTMON_EVMON_ACTIVITIES_1650497694126 0
    RTMON_EVMON_ACTIVITIES_1650497088569 0
    RTMON_EVMON_ACTIVITIES_1650496784964 0
    RTMON_EVMON_STATS 1
    RTMON_EVMON_ACTIVITIES_1650629360705 1
    RTMON_EVMON_ACTIVITIES_1650629057196 0
    RTMON_EVMON_ACTIVITIES_1650595862837 0
    RTMON_EVMON_ACTIVITIES_1650595560667 0
    RTMON_EVMON_ACTIVITIES_1650595257926 0
    RTMON_EVMON_ACTIVITIES_1650594954329 0
    RTMON_EVMON_ACTIVITIES_1650591321014 0
    RTMON_EVMON_ACTIVITIES_1650591014986 0
    RTMON_EVMON_ACTIVITIES_1650590712642 0
    RTMON_EVMON_ACTIVITIES_1650590105122 0
    RTMON_EVMON_ACTIVITIES_1650584026741 0
    RTMON_EVMON_ACTIVITIES_1650583422768 0
    RTMON_EVMON_ACTIVITIES_1650583118784 0
    RTMON_EVMON_ACTIVITIES_1650581898041 0
    RTMON_EVMON_ACTIVITIES_1650574294269 0
    RTMON_EVMON_ACTIVITIES_1650573989264 0
    RTMON_EVMON_ACTIVITIES_1650573685370 0
    RTMON_EVMON_ACTIVITIES_1650573379180 0
    RTMON_EVMON_ACTIVITIES_1650563953425 0
    RTMON_EVMON_ACTIVITIES_1650563348197 0
    RTMON_EVMON_ACTIVITIES_1650562740132 0
    RTMON_EVMON_ACTIVITIES_1650562437970 0
    RTMON_EVMON_ACTIVITIES_1650536316711 0
    RTMON_EVMON_ACTIVITIES_1650536014800 0
    RTMON_EVMON_ACTIVITIES_1650535409252 0
    RTMON_EVMON_ACTIVITIES_1650534800693 0
    RTMON_EVMON_ACTIVITIES_1650527513001 0
    RTMON_EVMON_ACTIVITIES_1650527209605 0
    RTMON_EVMON_ACTIVITIES_1650526298202 0
    RTMON_EVMON_ACTIVITIES_1650525688435 0
    RTMON_EVMON_ACTIVITIES_1650511375940 0
    RTMON_EVMON_ACTIVITIES_1650511066047 0
    RTMON_EVMON_ACTIVITIES_1650510460606 0
    RTMON_EVMON_ACTIVITIES_1650510156158 0
    RTMON_EVMON_ACTIVITIES_1650505903556 0
    RTMON_EVMON_ACTIVITIES_1650505597241 0
    RTMON_EVMON_ACTIVITIES_1650504991415 0
    RTMON_EVMON_ACTIVITIES_1650504688088 0
    RTMON_EVMON_ACTIVITIES_1650628147485 0
    RTMON_EVMON_ACTIVITIES_1650627539634 0
    RTMON_EVMON_ACTIVITIES_1650627232217 0
    RTMON_EVMON_ACTIVITIES_1650616270156 0
    RTMON_EVMON_ACTIVITIES_1650615661778 0
    RTMON_EVMON_ACTIVITIES_1650615357854 0
    RTMON_EVMON_ACTIVITIES_1650614753204 0
    RTMON_EVMON_ACTIVITIES_1650608647481 0
    RTMON_EVMON_ACTIVITIES_1650608342909 0
    RTMON_EVMON_ACTIVITIES_1650599820977 0
    RTMON_EVMON_ACTIVITIES_1650599516628 0
    RTMON_EVMON_ACTIVITIES_1650579459880 0
    RTMON_EVMON_ACTIVITIES_1650578854629 0
    RTMON_EVMON_ACTIVITIES_1650578549794 0
    RTMON_EVMON_ACTIVITIES_1650578248122 0
    RTMON_EVMON_ACTIVITIES_1650542704114 0
    RTMON_EVMON_ACTIVITIES_1650542088502 0
    RTMON_EVMON_ACTIVITIES_1650541783991 0
    RTMON_EVMON_ACTIVITIES_1650541481816 0
    RTMON_EVMON_ACTIVITIES_1650529950828 0
    RTMON_EVMON_ACTIVITIES_1650529339746 0
    RTMON_EVMON_ACTIVITIES_1650529034132 0
    RTMON_EVMON_ACTIVITIES_1650528121984 0
    RTMON_EVMON_ACTIVITIES_1650513504281 0
    RTMON_EVMON_ACTIVITIES_1650513201128 0
    RTMON_EVMON_ACTIVITIES_1650512898743 0
    RTMON_EVMON_ACTIVITIES_1650511983620 0
    RTMON_EVMON_ACTIVITIES_1650507725949 0
    RTMON_EVMON_ACTIVITIES_1650507423751 0
    RTMON_EVMON_ACTIVITIES_1650506820847 0
    RTMON_EVMON_ACTIVITIES_1650506515792 0
    RTMON_EVMON_ACTIVITIES_1650502557818 0
    RTMON_EVMON_ACTIVITIES_1650502254804 0
    RTMON_EVMON_ACTIVITIES_1650501950591 0
    RTMON_EVMON_ACTIVITIES_1650501342134 0
    SAP_WLM_STATISTICS 1
    SAP_WLM_ACTIVITIES 1
    RTMON_EVMON_ACTIVITIES_1650617795574 0
    RTMON_EVMON_ACTIVITIES_1650617485714 0
    RTMON_EVMON_ACTIVITIES_1650617181383 0
    RTMON_EVMON_ACTIVITIES_1650616570590 0
    RTMON_EVMON_ACTIVITIES_1650577943037 0
    RTMON_EVMON_ACTIVITIES_1650577638451 0
    RTMON_EVMON_ACTIVITIES_1650577035165 0
    RTMON_EVMON_ACTIVITIES_1650576732831 0
    RTMON_EVMON_ACTIVITIES_1650569731900 0
    RTMON_EVMON_ACTIVITIES_1650569428262 0
    RTMON_EVMON_ACTIVITIES_1650568820760 0
    RTMON_EVMON_ACTIVITIES_1650568515763 0
    RTMON_EVMON_ACTIVITIES_1650557888891 0
    RTMON_EVMON_ACTIVITIES_1650557585900 0
    RTMON_EVMON_ACTIVITIES_1650557280306 0
    RTMON_EVMON_ACTIVITIES_1650556979448 0
    RTMON_EVMON_ACTIVITIES_1650553937822 0
    RTMON_EVMON_ACTIVITIES_1650553633712 0
    RTMON_EVMON_ACTIVITIES_1650553329478 0
    RTMON_EVMON_ACTIVITIES_1650552411542 0
    RTMON_EVMON_ACTIVITIES_1650549676012 0
    RTMON_EVMON_ACTIVITIES_1650549069330 0
    RTMON_EVMON_ACTIVITIES_1650548768196 0
    RTMON_EVMON_ACTIVITIES_1650548157943 0
    RTMON_EVMON_ACTIVITIES_1650547853547 0
    RTMON_EVMON_ACTIVITIES_1650547246903 0
    RTMON_EVMON_ACTIVITIES_1650546946944 0
    RTMON_EVMON_ACTIVITIES_1650546340549 0
    RTMON_EVMON_ACTIVITIES_1650501036088 0
    RTMON_EVMON_ACTIVITIES_1650500430265 0
    RTMON_EVMON_ACTIVITIES_1650500126010 0
    RTMON_EVMON_ACTIVITIES_1650499822781 0
    RTMON_EVMON_ACTIVITIES_1650621456118 0
    RTMON_EVMON_ACTIVITIES_1650621146138 0
    RTMON_EVMON_ACTIVITIES_1650620836569 0
    RTMON_EVMON_ACTIVITIES_1650619924668 0
    RTMON_EVMON_ACTIVITIES_1650573072790 0
    RTMON_EVMON_ACTIVITIES_1650572466406 0
    RTMON_EVMON_ACTIVITIES_1650572163264 0
    RTMON_EVMON_ACTIVITIES_1650571551634 0
    RTMON_EVMON_ACTIVITIES_1650562135687 0
    RTMON_EVMON_ACTIVITIES_1650561526668 0
    RTMON_EVMON_ACTIVITIES_1650560915936 0
    RTMON_EVMON_ACTIVITIES_1650560613176 0
    RTMON_EVMON_ACTIVITIES_1650546039094 0
    RTMON_EVMON_ACTIVITIES_1650545427952 0
    RTMON_EVMON_ACTIVITIES_1650545127397 0
    RTMON_EVMON_ACTIVITIES_1650544519898 0
    RTMON_EVMON_ACTIVITIES_1650534498714 0
    RTMON_EVMON_ACTIVITIES_1650533590828 0
    RTMON_EVMON_ACTIVITIES_1650532977899 0
    RTMON_EVMON_ACTIVITIES_1650532675998 0
    RTMON_EVMON_ACTIVITIES_1650523237897 0
    RTMON_EVMON_ACTIVITIES_1650522625991 0
    RTMON_EVMON_ACTIVITIES_1650522318138 0
    RTMON_EVMON_ACTIVITIES_1650522011089 0
    RTMON_EVMON_ACTIVITIES_1650495868854 0
    RTMON_EVMON_ACTIVITIES_1650495262223 0
    RTMON_EVMON_ACTIVITIES_1650494957573 0
    RTMON_EVMON_ACTIVITIES_1650494653468 0
    RTMON_EVMON_ACTIVITIES_1650624197479 0
    RTMON_EVMON_ACTIVITIES_1650623892514 0
    RTMON_EVMON_ACTIVITIES_1650623586886 0
    RTMON_EVMON_ACTIVITIES_1650622975069 0
    RTMON_EVMON_ACTIVITIES_1650610475892 0
    RTMON_EVMON_ACTIVITIES_1650610170387 0
    RTMON_EVMON_ACTIVITIES_1650609865137 0
    RTMON_EVMON_ACTIVITIES_1650609254165 0
    RTMON_EVMON_ACTIVITIES_1650576122889 0
    RTMON_EVMON_ACTIVITIES_1650575817491 0
    RTMON_EVMON_ACTIVITIES_1650575209160 0
    RTMON_EVMON_ACTIVITIES_1650574904168 0
    RTMON_EVMON_ACTIVITIES_1650539048540 0
    RTMON_EVMON_ACTIVITIES_1650538740186 0
    RTMON_EVMON_ACTIVITIES_1650538437052 0
    RTMON_EVMON_ACTIVITIES_1650538132455 0
    RTMON_EVMON_ACTIVITIES_1650619317915 0
    RTMON_EVMON_ACTIVITIES_1650619011237 0
    RTMON_EVMON_ACTIVITIES_1650618401068 0
    RTMON_EVMON_ACTIVITIES_1650618096449 0
    RTMON_EVMON_ACTIVITIES_1650614451169 0
    RTMON_EVMON_ACTIVITIES_1650613844945 0
    RTMON_EVMON_ACTIVITIES_1650613543176 0
    RTMON_EVMON_ACTIVITIES_1650612928686 0
    RTMON_EVMON_ACTIVITIES_1650597693171 0
    RTMON_EVMON_ACTIVITIES_1650597384975 0
    RTMON_EVMON_ACTIVITIES_1650596774430 0
    RTMON_EVMON_ACTIVITIES_1650596471736 0
    RTMON_EVMON_ACTIVITIES_1650592837076 0
    RTMON_EVMON_ACTIVITIES_1650592230898 0
    RTMON_EVMON_ACTIVITIES_1650591925994 0
    RTMON_EVMON_ACTIVITIES_1650591622721 0
    RTMON_EVMON_ACTIVITIES_1650587057270 0
    RTMON_EVMON_ACTIVITIES_1650586750494 0
    RTMON_EVMON_ACTIVITIES_1650585233425 0
    RTMON_EVMON_ACTIVITIES_1650584931618 0
    RTMON_EVMON_ACTIVITIES_1650581594193 0
    RTMON_EVMON_ACTIVITIES_1650581291369 0
    RTMON_EVMON_ACTIVITIES_1650580374358 0
    RTMON_EVMON_ACTIVITIES_1650579761697 0
    RTMON_EVMON_ACTIVITIES_1650567905120 0
    RTMON_EVMON_ACTIVITIES_1650567601223 0
    RTMON_EVMON_ACTIVITIES_1650567299178 0
    RTMON_EVMON_ACTIVITIES_1650566995986 0
    RTMON_EVMON_ACTIVITIES_1650556066361 0
    RTMON_EVMON_ACTIVITIES_1650555452706 0
    RTMON_EVMON_ACTIVITIES_1650555149764 0
    RTMON_EVMON_ACTIVITIES_1650554241118 0
    RTMON_EVMON_ACTIVITIES_1650537830265 0
    RTMON_EVMON_ACTIVITIES_1650537224668 0
    RTMON_EVMON_ACTIVITIES_1650536922888 0
    RTMON_EVMON_ACTIVITIES_1650536620178 0
    RTMON_EVMON_ACTIVITIES_1650525381354 0
    RTMON_EVMON_ACTIVITIES_1650524462635 0
    RTMON_EVMON_ACTIVITIES_1650523850174 0
    RTMON_EVMON_ACTIVITIES_1650523543744 0
    RTMON_EVMON_UTILITY 1

    Best regards,
    Joachim

    ------------------------------
    Joachim Müller
    ------------------------------


  • 2.  RE: Event monitor

    Posted Fri April 22, 2022 08:43 AM
    Hello Joachim,
    Question, do you have ATS enabled for your Activity Event monitor:

    If not, that would explain all those event monitors on the monitored database.
    My recommendation is to stop monitoring the database in DMC, drop all event monitors manually, and restart monitoring the database again.
    Probably something happened to your DMC server, which could have triggered this behavior.
    If the problem happens again, you might want to create a case and send us the DMC collector for further analysis.
    I hope that helps!

    ------------------------------
    Cintia Ogura
    ------------------------------



  • 3.  RE: Event monitor

    Posted Fri April 22, 2022 09:03 AM
    Hello Cintia,

    ATS is running, there are other databases involved...
    Before I drop all the event monitors, please have a look in the collector files.

    See Case TS009134530

    Best regards,
    Joachim

    ------------------------------
    Joachim Müller
    ------------------------------