DB2 Version 9.7 for Linux, UNIX, and Windows

db2eva - Event analyzer command

Starts the event analyzer, allowing the user to trace performance data produced by DB2® event monitors that have their data directed to tables.

Important: This command has been deprecated and might be removed in a future release because the Control Center and its associated components have been deprecated in Version 9.7. It is not supported in DB2 pureScale® environments. For more information, see Control Center tools have been deprecated.

Authorization

All of the following privileges and authorizations are required:
  • CONNECT authority (or an authority that implicitly includes CONNECT authority)
  • SELECT privilege on the following catalog tables (or an authority that implicitly includes SELECT privilege on the catalog tables):
    • SYSIBM.EVENTMONITORS
    • SYSIBM.EVENTS
    • SYSIBM.EVENTTABLE

Required connection

Database connection

Command syntax

Read syntax diagramSkip visual syntax diagram
>>-db2eva--+------------------------+--+-------------------+---><
           '- -db-- -database-alias-'  '- -evm--evmon-name-'   

Command parameters

The db2eva parameters are optional. If you do not specify parameters, the Open Event Analyzer dialog box appears to prompt you for the database and event monitor name.

-db database-alias
Specifies the name of the database defined for the event monitor.
-evm evmon-name
Specifies the name of the event monitor whose traces are to be analyzed.

Usage notes

Without the required access, the user cannot retrieve any event monitor data.

There are two methods for retrieving event monitor traces:
  1. The user can enter db2eva from the command line and the Open Event Analyzer Dialog box opens to let the user choose the database and event monitor names from the drop-down lists before clicking OK to open the Event Analyzer dialog box.
  2. The user can specify the -db and -evm parameters from the command line and the Event Analyzer dialog opens on the specified database.

The Event Analyzer connects to the database, and issues a select target from SYSCAT.EVENTTABLES to get the event monitor tables. The connection is then released after the required data has been retrieved.

The event analyzer can be used to analyze the data produced by an active event monitor. However, event monitor captured after the event analyzer has been invoked might not be shown. Turn off the event monitor before invoking the Event Analyzer to ensure data are properly displayed.