Unformatted event table column definitions

An unformatted event table is created when you issue a CREATE EVENT MONITOR statement that includes the clause WRITE TO UNFORMATTED EVENT TABLE. The column definitions are useful when you want to extract data to analyze or prune a table of unneeded data.

The column definitions for the unformatted event table are useful when you want to extract data from an unformatted event table using one of the following routines:
  • EVMON_FORMAT_UE_TO_XML - extracts data from an unformatted event table into an XML document.
  • EVMON_FORMAT_UE_TO_TABLES - extracts data from an unformatted event table into a set of relational tables.
The call to these routines accepts a SELECT statement that specifies the rows that you want to extract. Use the unformatted event table column definitions to assist with composing your SELECT statement.

There is no automatic purging of the event data written to an unformatted event table. You must manually purge data from the table. The column definitions for the unformatted event table are useful when you want to purge a targeted set of records. Another option is to remove all the table rows using the TRUNCATE TABLE statement.

As part of the CREATE EVENT MONITOR statement, you can specify what to name the associated unformatted event table. If not specified, the name defaults to the same name as the event monitor. The SYSCAT.EVENTTABLES catalog view lists event monitors, their associated unformatted table, and other details.

The following table describes the columns in the unformatted event table. The key column is the event_data column. The other columns represent identifiers that you can use to locate events of interest. For further attributes of table columns, issue a DESCRIBE statement.

Table 1. Unformatted event table column definitions
Column name Column data type Column description
appl_id VARCHAR appl_id - Application ID monitor element
appl_name VARCHAR appl_name - Application name monitor element
event_correlation_id BIT DATA An optional event correlation ID. A NULL value indicates that the event correlation ID was not available.
The value is based on the event monitor type:
  • LOCKING - Reserved for future use
  • UOW- Reserved for future use
event_data BLOB The entire event record data for an event captured by the event monitor, stored in its original binary form.
event_id INTEGER event_id - Event ID monitor element
event_timestamp TIMESTAMP event_timestamp - Event timestamp monitor element
event_type

VARCHAR

 event_type - Event Type monitor element monitor element
member SMALLINT member - Database member monitor element
partitioning_key INTEGER The partitioning key for the table, so that insert operations are performed locally on the database partition where the event monitor is running.
record_seq_num INTEGER The sequence number of the record that is stored within the event_data column.
record_type INTEGER The type of record that is stored within the event_data column.
service_subclass_name VARCHAR service_subclass_name - Service subclass name monitor element
service_superclass_name VARCHAR service_superclass_name - Service superclass name monitor element
workload_name VARCHAR workload_name - Workload name monitor element
mon_interval_id BIGINT mon_interval_id - Monitor interval identifier monitor element