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.
- 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.
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.
|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:
|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 - Event Type 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|