DB2 Version 9.7 for Linux, UNIX, and Windows

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 SNAPSHOT_DATABASE table function.
dataaccess

Required connection

None

Command syntax


>>-db2evmon----------------------------------------------------->

>--+-------------------------------------------------+---------><
   +- -db--database-alias-- -evm--event-monitor-name-+   
   '- -path--event-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, the command will start the instance.
If the instance is not already started when db2evmon is issued with the -path option, the command will not start the instance. The instance needs to be started explicitly.

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.