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 replaces
the DB2_SNAPSHOT_NOAUTH
registry variable as 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