Access to system monitor data: SYSMON authority

Users that are part of the SYSMON database manager level group have the authority to gain access to database system monitor data. System monitor data is accessed using the snapshot monitor APIs, CLP commands, or SQL table functions.

The SYSMON authority group provides the means to enable users without system administration or system control authorities to access database system monitor data.

Aside from SYSMON authority, the only way to access system monitor data using the snapshot monitor is with system administration or system control authority.

Any user that is part of the SYSMON group or has system administration or system control authority can perform the following snapshot monitor functions:
  • CLP Commands:
    • GET DATABASE MANAGER MONITOR SWITCHES
    • GET MONITOR SWITCHES
    • GET SNAPSHOT
    • LIST ACTIVE DATABASES
    • LIST APPLICATIONS
    • LIST DCS APPLICATIONS
    • LIST UTILITIES
    • RESET MONITOR
    • UPDATE MONITOR SWITCHES
  • APIs:
    • db2GetSnapshot - Get Snapshot
    • db2GetSnapshotSize - Estimate Size Required for db2GetSnapshot() Output Buffer
    • db2MonitorSwitches - Get/Update Monitor Switches
    • db2ResetMonitor - Reset Monitor
  • Snapshot SQL table functions without previously running SYSPROC.SNAP_WRITE_FILE
    Important: The SYSPROC.SNAP_WRITE_FILE procedure is deprecated in Version 10.5 and might be removed in a future release. For more information, see SNAP_WRITE_FILE procedure.