Online Documentation for SQL Manager for DB2

Event Monitors


An Event Monitor is a database object for monitoring and collecting data on database activities over a period of time.

 

 

Creating Event Monitors

 

To create a new event monitor:

Hint: To create a new event monitor, you can also right-click the Event Monitors node of the DB Explorer tree and select the Event Monitor... context menu item.

 

To create a new event monitor with the same properties as one of existing event monitors has:

Alternatively, you can right-click an event monitor in the DB Explorer tree and select the Duplicate Event Monitor <event_monitor_name>... context menu item.

 

Duplicate Object Wizard allows you to select the database to create a new event monitor in, and to edit the result SQL statement for creating the event monitor.

 

 

Editing Event Monitors

 

To edit an existing event monitor:

  • select the event monitor for editing in the DB Explorer tree (type the first letters of the event monitor name for quick search);
  • right-click the object and select the Edit Event Monitor <event_monitor_name>... context menu item, or simply double-click the event monitor;
  • edit event monitor definition using the appropriate tabs of Event Monitor Editor.

 

Dropping Event Monitors

 

To drop an event monitor:

  • select the event monitor to drop in the DB Explorer tree;
  • right-click the object and select the Drop Event Monitor <event_monitor_name>... context menu item;
  • confirm dropping in the dialog window.

 

Note: If more convenient, you can also use the following shortcuts:

Ctrl+N to create a new event monitor;

Ctrl+O to edit the selected event monitor;

Shift+Del to drop the object from the database.