DB2 Version 9.7 for Linux, UNIX, and Windows

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.