Event Monitors Wizard (DB2 LUW)
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:
- Open a creation wizard for an event monitor. For details, see Opening an Object Wizard.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Properties panel - for details, see Event Monitors (DB2 LUW) - Properties.
- Definition panel - for details, see Event Monitors (DB2 LUW) - Definition.
- Conditions panel - for details, see Event Monitors (DB2 LUW) - Conditions.
- DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
- 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 |
---|---|
Name |
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 |
Blocked |
For a Target Type of TABLE or FILE, indicate whether the event monitor is to be blocked. |
Target |
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.
The base set of event types is BUFFERPOOLS, CONNECTIONS, DATABASE, DEADLOCKS, DEADLOCK WITH DETAILS, STATEMENTS, TABLES, TABLESPACES, and TRANSACTIONS.
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.