Privileges for DB2 and DB2 for z/OS
To automatically create schemas, tables, and views during monitor model deployment, undeployment, and data movement services (DMS) enablement, the user-specified authentication alias for Monitor_Admin_Database must be granted DBADM authority. If the authentication alias that is associated with the Monitor_Admin_Database does not have at least DBADM authority, you must manually create the database schema for monitor model installation and DMS enablement.
When using DB2® for z/OS®, do not automatically create the schema during monitor model installation. Instead, create the schema manually, but ensure that you have SYSADM authority.
The following table describes the database grants that are required
for the user that is specified in the Monitor_Database authentication
alias.
| Database privilege | Scope |
|---|---|
| SELECT | All tables and views in the MONITOR schema and all tables and views in the monitor model schema |
| INSERT | All tables and views in the MONITOR schema and all tables and views in the monitor model schema |
| UPDATE | All tables and views in the MONITOR schema and all tables and views in the monitor model schema |
| DELETE | All tables and views in the MONITOR schema and all tables and views in the monitor model schema |
| EXECUTE | All stored procedures in the monitor model schema |