Db2

  • 1.  DMC 3.1.2 Activate Lock Event Monitor Not Working

    Posted Wed July 29, 2020 03:29 AM
    Hello,

    I just upgraded to DMC 3.1.2. Then I wanted to create the lock event monitor for one of the monitored databases. But on the event monitor profile page, it is not possible to save the change because the "Save" button remains inactive!?! Note that ATS is currently not enabled for the database and I also did not want to activate it. Hence I deselected the "Use ATS" option on the page.

    So question is: Why is it not possible to create the lock event monitor for the database, i.e. why does the "Save" button remain inactive although I changed the lock event monitor setting?



    ------------------------------
    Dirk Fechner
    ------------------------------

    #Db2


  • 2.  RE: DMC 3.1.2 Activate Lock Event Monitor Not Working

    Posted Thu July 30, 2020 08:38 AM
    Hello Dirk,
    In your screen shot, I don't see the event monitor tablespace definition.
    Question for you, did you create the tablespace for the event monitors?
    When you created the tablespace, did you use the default recommendation by DMC?
    If you change the default configuration recommended by DMC, specially the maxsize option (most common scenario), DMC won't create the tablespace for security reasons, and you won't be able to update the event monitor configuration.
    Another problem could be missing privileges to create the event monitors.
    Please make sure that your userid has the requirements according to the DMC manual at:
    https://www.ibm.com/support/knowledgecenter/SS5Q8A_3.1.x/com.ibm.datatools.dsweb.ots.security.doc/topics/Minimum_Database_Privileges_Required_on_LUW.html
    If you have checked all requirements and still have the issue, you can create a case with us, and I can check the log files for any additional errors.
    I hope that helps!



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



  • 3.  RE: DMC 3.1.2 Activate Lock Event Monitor Not Working

    Posted Thu July 30, 2020 11:46 AM
    Hello Cintia,

    I checked again the "Event monitor profile" site and recognized that I missed to press the "Specify a table space" button. Having pressed the button, the "Save" button became active. So, that problem is solved. Thanks

    But one more question. After specifying the table space for the event monitors, I could not find a possibility to change the table space selection. Is that supported?



    ------------------------------
    Dirk Fechner
    ------------------------------



  • 4.  RE: DMC 3.1.2 Activate Lock Event Monitor Not Working

    Posted Thu July 30, 2020 12:25 PM
    Edited by System Fri January 20, 2023 04:51 PM
    Hello Dirk,
    I am glad to hear that the event monitor page is working now.
    The easiest way to change the tablespace is by disabling all event monitors in DMC, so DMC drops the event monitors and tables.
    Then on the monitored database, you manually drop the existing tablespace.
    Once you dropped the tablespace, you can go back to the event monitor configuration, and DMC should request the new tablespace again.
    I hope that helps!

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



  • 5.  RE: DMC 3.1.2 Activate Lock Event Monitor Not Working

    Posted Thu July 30, 2020 12:47 PM
    Hello Cintia,

    ok, thanks, I will try that.

    ------------------------------
    Dirk Fechner
    ------------------------------