Event Monitors Wizard (DB2 LUW)

From DBArtisan
Jump to: navigation, search

Go Up to IBM DB2 for Linux, Unix, and Windows Object Wizards

An event monitor is used to collect information about a particular database and connected appliances when one or more events you specify take(s) place. Where a snapshot monitor captures information for a given moment in time, the event monitor lets you trace the activity you specify.

The Event Monitor Wizard lets you provide basic properties, select event types, and specify conditions where appropriate, for an event monitor.

To create a new event monitor using a wizard:

  1. Open a creation wizard for an event monitor. For details, see Opening an Object Wizard.
  2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
  3. Finally, use the Execute button to create the object.

Event Monitors (DB2 LUW) - Properties

When creating or editing an event monitor, this tab/panel lets you work with the following settings:

Setting Description


The name used to reference the object.

Auto Start

Indicates whether the event monitor is activated each time the database starts.

Target Type

Indicates where the output is written: FILE, PIPE, or TABLE.

Buffer Size

For a Target Type of TABLE or FILE, indicates the buffer size


For a Target Type of TABLE or FILE, indicate whether the event monitor is to be blocked.


For a Target Type of PIPE, a named pipe identifier.

Write Mode

For a Target Type of FILE, the value can be APPEND or REPLACE.

Max Files

For a Target Type of FILE, indicate the maximum number of files.

Max FIle Size

For a Target Type of FILE, indicates the maximum file size.

Event Monitors (DB2 LUW) - Definition

This tab/panel lets you specify the Event Types used to construct the CREATE EVENT MONITOR statement FOR clause.


For IBM DB2 for Linux, Unix, and Windows version 9.0, DEADLOCK WITH DETAILS HISTORY and DEADLOCKS WITH DETAILS HISTORY VALUES event types are available.

For IBM DB2 for Linux, Unix, and Windows version 9.5, ACTIVITIES, THRESHOLD VIOLATIONS, and STATISTICS event types are available.

Note: If your choices are all from the DEADLOCKS... types, you can also specify Deadlock Monitoring of Global or Local. If you select Local, specify the Database Partitions the event monitor is to run against.

Event Monitors (DB2 LUW) - Conditions

Available only for CONNECTION, STATEMENT, and TRANSACTION Event Types, this tab lets you identify a condition used to determine which CONNECTION, STATEMENT, or TRANSACTION the event monitor will collect data for.