Db2

Db2

Connect with Db2, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  db not monitored

    Posted Tue April 28, 2020 10:24 AM
    Hi, 

    There are a database configured, but not monitored in DMC. How do i fix this?
    I need the database with the status of monitored to have access to the dashboard. 



    ------------------------------
    Viviane Urbano de Araujo Franco
    ------------------------------

    #Db2


  • 2.  RE: db not monitored

    Posted Tue April 28, 2020 12:12 PM
    have you used a monitor profile : existing or new ?
    at this profile, you have to attach the database(s) you want to follow this profile
    there are different options in the profile that can be activated..

    ------------------------------
    Thanks for all answers
    Best Regards,
    Guy Przytula
    ------------------------------

    Original Message


  • 3.  RE: db not monitored

    Posted Tue April 28, 2020 01:40 PM
    Hi Guy, I was not the one who set up the Db2 Data Management Console.

    In the 'monitor profile' the name is 'default'. I tried to set up a new profile, but now I see that the database list is empty.
    Default profile
    Select connections - Empty list


    ------------------------------
    Viviane Urbano de Araujo Franco
    ------------------------------

    Original Message


  • 4.  RE: db not monitored

    Posted Wed April 29, 2020 03:18 AM
    when you create the profile or edit existing profile : on first page you can select databases to use this profile

    ------------------------------
    Thanks for all answers
    Best Regards,
    Guy Przytula
    ------------------------------

    Original Message


  • 5.  RE: db not monitored

    Posted Thu April 30, 2020 10:46 AM

    You need to make sure you have the necessary privileges granted to the DSM monitoring ID on the target DBs. 

    Otherwise, the monitoring wont work and will stat as it is...  "Not Monitored"  they could be more specific in telling you why..   but ... 

    Also,  I lacked to see a proper documentation on DMC for this..  This needs an URGENT improvement in product documentation. 

    I used the documentation from old DSM. 

    https://www.ibm.com/support/knowledgecenter/SS5Q8A_2.1.x/com.ibm.datatools.dsweb.ots.security.doc/topics/Privileges_required_for_the_ID_used_by_IBM_Data_Server_Manager.html

    Follow this,  and see if it works properly after that.. 

    Regards



    ------------------------------
    Samuel Pizarro
    ------------------------------

    Original Message


  • 6.  RE: db not monitored

    Posted Fri May 15, 2020 03:32 PM
    Hello all,
    I have similar issue. Monitoring profile is set correctly (I see database as available), persistance is set to ON (keep data for 7 days), monitoring user has privilage (used the same as in DSM where it was working), but still IBMCONSOLE.DBSTATUS doesn't receive any data.

    Any thoughts, what to check, are more than welcome

    ------------------------------
    Juraj Kotisa
    ------------------------------

    Original Message


  • 7.  RE: db not monitored

    Posted Mon May 18, 2020 08:27 AM
    I set up other database in the DMC and they were monitored normally, but that what I really needed remained unmonitored.

    The solution given by my team was to uninstall the DMC and reinstall the DSM. With DSM, monitoring takes place correctly. 

    ------------------------------
    Viviane Urbano de Araujo Franco
    ------------------------------

    Original Message


  • 8.  RE: db not monitored

    Posted Mon May 18, 2020 08:44 AM
    so did we. we returned to dsm and waiting another year before dmc gets stable..

    ------------------------------
    Thanks for all answers
    Best Regards,
    Guy Przytula
    ------------------------------

    Original Message


Related Content