System monitor authority (SYSMON)

SYSMON authority provides the ability to take database system monitor snapshots of a database manager instance or its databases.

SYSMON authority is assigned to the group specified by the sysmon_group configuration parameter. If a group is specified, membership in that group is controlled outside the database manager through the security facility used on your platform.

SYSMON authority enables the user to run the following commands:
  • GET DATABASE MANAGER MONITOR SWITCHES
  • GET MONITOR SWITCHES
  • GET SNAPSHOT
  • LIST (some commands):
    • LIST ACTIVE DATABASES
    • LIST APPLICATIONS
    • LIST DATABASE PARTITION GROUPS
    • LIST DCS APPLICATIONS
    • LIST PACKAGES
    • LIST TABLES
    • LIST TABLESPACE CONTAINERS
    • LIST TABLESPACES
    • LIST UTILITIES
  • RESET MONITOR
  • UPDATE MONITOR SWITCHES
SYSMON authority enables the user to use the following APIs:
  • db2GetSnapshot - Get Snapshot
  • db2GetSnapshotSize - Estimate Size Required for db2GetSnapshot() Output Buffer
  • db2MonitorSwitches - Get/Update Monitor Switches
  • db2mtrk - Memory tracker
  • db2ResetMonitor - Reset Monitor
SYSMON authority enables the user use the following SQL table functions:
  • All snapshot table functions without previously running SYSPROC.SNAP_WRITE_FILE

    SYSPROC.SNAP_WRITE_FILE takes a snapshot and saves its content into a file. If any snapshot table functions are called with null input parameters, the file content is returned instead of a real-time system snapshot.

    Important: The SYSPROC.SNAP_WRITE_FILE procedure is deprecated and might be removed in a future release. For more information, see SNAP_WRITE_FILE procedure.