Required authority

The information in this section applies only if you do not use the user authorization exit.

If the user exit is active, the description about the user authorization exit provided in IBM® DB2® for z/OS® in the IBM Knowledge Center applies.

To use the Online Monitor, you need the following authorities:
  • Access to a Db2 subsystem
  • EXECUTE authority on the Online Monitor plan. The plan name is KO2PLAN.
  • MONITOR1 privilege
  • Display trace privilege

You also need the Db2 authority for any Db2 commands you issue.

The following authorities are recommended:
  • MONITOR2 or SYSADM privilege if you need access to the currently executing SQL statement
  • Db2 privilege to start or stop a Db2 trace, if you want to collect report data
Important: Granting MONITOR2 privilege enables access to potentially sensitive data, for example, the SQL statement being executed.