db2evmon - Event monitor productivity tool command

Formats event monitor file and named pipe output, and writes it to standard output.

Authorization

None, unless connecting to the database (-db -evm) in which case, all of the following authorization is required:
  • CONNECT authority (or an authority that implicitly includes CONNECT)
  • SELECT privilege on the following catalog tables (or an authority that implicitly includes SELECT on the catalog tables):
    • SYSIBM.SYSTABLES
    • SYSIBM.SYSEVENTMONITORS
If the event monitor is db2detaildeadlock, then one of the following authorities or privilege is additionally required:
  • SYSMON
  • SYSMAINT
  • SYSCTRL
  • SYSADM
  • EXECUTE privilege on the MON_GET_DATABASE table function.
  • DATAACCESS

Required connection

None

Command syntax

Read syntax diagramSkip visual syntax diagramdb2evmon-dbdatabase-alias-evmevent-monitor-name-pathevent-monitor-target

Command parameters

-db database-alias
Specifies the database whose data is to be displayed. This parameter is case sensitive.
-evm event-monitor-name
The one-part name of the event monitor. An ordinary or delimited SQL identifier. This parameter is case sensitive.
-path event-monitor-target
Specifies the directory containing the event monitor trace files.

Usage notes

db2evmon generates the same output regardless of whether the command is issued while connecting to the database or specifying the path option.
  • If the instance is not already started when db2evmon is issued with the -db and -evm options, db2evmon will not start the instance automatically. It needs to be started manually.
  • If the instance is not already started when db2evmon is issued with the -path option, it will format event files based on the path location.

If the data is being written to files, the tool formats the files for display using standard output. In this case, the monitor is turned on first, and any event data in the files is displayed by the tool. To view any data written to files after the tool has been run, reissue db2evmon.

If the data is being written to a pipe, the tool formats the output for display using standard output as events occur. In this case, the tool is started before the monitor is turned on.