DB2 10.5 for Linux, UNIX, and Windows

Workload management administrator authority (WLMADM)

You need workload management administrator (WLMADM) authority to manage workload objects for a specific database. This authority enables you to create, alter, drop, comment on, grant access to, and revoke access from DB2® workload management objects.

Workload management objects are system objects similar to buffer pools and table spaces. As such, they do not have owners associated with them.

The security administrator, who is someone holding SECADM authority, or a user with ACCESSCTRL authority can grant WLMADM authority to a user, group, or role.

WLMADM authority provides the ability to perform the following tasks:
  • Issue CREATE, ALTER, COMMENT ON, and DROP statements for the following DB2 workload management objects:
    • Histogram templates
    • Service classes
    • Thresholds
    • Work action sets
    • Work class sets
    • Workloads
  • Issue GRANT and REVOKE statements for workload privileges
If you hold database administrator (DBADM) authority, you hold WLMADM authority implicitly.