Db2 (On Premises and Cloud)

Expand all | Collapse all

DMC 3.1.4: Access rights and priviledges needed in database to monitor

  • 1.  DMC 3.1.4: Access rights and priviledges needed in database to monitor

    Posted Mon April 26, 2021 09:48 AM
    Hi,

    in a more tight customer scenario we try the get DMC 3.1.4 running.

    According to this Minimum database privileges required for Db2 KC page, I started with these permissions, but I still get
    errors in the DMC which return errors ('Can't display data' Click on refresh to continue, which doesn't help)

    GRANT CONNECT, SQLADM, IMPLICIT_SCHEMA ON DATABASE TO USER DMCMON ;
    GRANT CREATETAB ON DATABASE TO USER DMCMON ;
    GRANT USAGE ON WORKLOAD SYSDEFAULTUSERWORKLOAD TO USER DMCMON ;
    GRANT EXECUTE ON PACKAGE NULLID.SYSSH200 TO USER DMCMON ;
    GRANT EXECUTE ON PACKAGE NULLID.SYSSH100 TO USER DMCMON ;
    GRANT EXECUTE ON PACKAGE NULLID.SYSSN200 TO USER DMCMON ;
    GRANT EXECUTE ON FUNCTION SYSPROC.* to user DMCMON;
    GRANT EXECUTE ON PROCEDURE SYSIBM.SQLCAMESSAGECCSID to user DMCMON;
    GRANT SELECT ON sysibm.sysdummy1 to USER DMCMON ;
    GRANT SELECT ON sysibm.sysversions to USER DMCMON ;
    GRANT SELECT ON SYSIBM.SYSUSERAUTH TO USER DMCMON ;

    Of course DBADM with DATAACCESS could fix it all, but that is not allowed in this environment.

    What are the minimal privileges and permissions on the database to monitor are needed to get basic monitoring
    or advanced monitoring running?

    Kind regards

    ------------------------------
    Roland Schock
    Distinguished Engineer
    ARS Computer und Consulting GmbH
    ------------------------------


  • 2.  RE: DMC 3.1.4: Access rights and priviledges needed in database to monitor

    Posted Thu May 06, 2021 04:32 PM
    Hi Roland,

    Do you have a case opened for this issue?  It will be good if we can have trace to look at the privilege issues that happened in the monitoring database.  Please let us know the case number.  Thanks.

    ------------------------------
    Jason Sizto
    ------------------------------