Methods for accessing information in unformatted event tables

There are different ways to access the information in unformatted event (UE) tables. You can generate a text report intended to be read. Alternatively, you can extract the data into relational tables or XML; this approach lets you query the data using SQL or pureXML®.

Event monitors that write to UE tables write event data in a binary format. You can access this data using the db2evmonfmt command or routines provided for this purpose.

With the db2evmonfmt command you can:

select events of interest based on the following attributes: event ID, event type, time period, application, workload, or service class.
choose whether to receive the output in the form of a text report or a formatted XML document.
completely control the output format by creating your own XSLT style sheets instead of using the ones provided with db2evmonfmt.

You can also extract data from an unformatted event table using 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.

With these two routines, you can use a SELECT statement to specify the exact rows from the unformatted event table that you want to extract.