Authorization
This topic describes the privileges required by the user ID for running the
dmctop monitoring utility.
User ID used with dmctop to monitor database requires the following privileges,.
For detailed privilege information, refer to the README file included in the package..
| Function | Objects | Authorization |
|---|---|---|
| Monitor | Table functions | |
| SYSPROC.MON_GET_* | Execute | |
|
SYSPROC.DB2_GET_INSTANCE_INFO |
Execute | |
|
SYSPROC.ENV_GET_SYSTEM_RESOURCES |
Execute | |
| SYSPROC.WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES | Execute | |
| SYSPROC.WLM_GET_SERVICE_CLASS_AGENTS | Execute | |
| SYSPROC.WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES | Execute | |
|
SYSPROC.ENV_GET_DB2_SYSTEM_RESOURCES |
Execute | |
| Tables | ||
| SYSIBMADM.MON_LOCKWAITS | Execute | |
| Format explain | Procedures | |
|
SYSPROC.EXPLAIN_FROM_SECTION |
Execute | |
| Tables | ||
|
Explain tables |
Select and insert |