Event Monitor Editor (IBM DB2 LUW)

From DBArtisan
Jump to: navigation, search

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

The event monitor editor lets you manage the event types associated with an event monitor, modify the condition for each event type, and specify where and how records are written.

To edit an event monitor

  1. Open an editor on the event monitor. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks

Properties

Lets you work with the following settings: Auto Start - lets you specify whether the event monitor is activated each time the database starts. Target Type - lets you specify where the output is written: FILE, PIPE, or TABLE. If you specify a Target Type of TABLE, you also have options to provide a Buffer SIze and specify whether the event monitor is to be Blocked. If you specify a Target Type of PIPE, you must also specify the Target named pipe identifier. If you specify a Target Type of FILE, you also have options to provide a Buffer SIze and whether the event monitor is to be Blocked. You also specify a Write Mode of APPEND or REPLACE, provide a Max Files value and a Max File Size value.

Definition

Lets you modify 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.

Conditions

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

DDL

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.
Retrieved from "https://docwiki.embarcadero.com/DBArtisan/180/e/index.php?title=Event_Monitor_Editor_(IBM_DB2_LUW)&oldid=4596"