Routines for extracting data from unformatted event tables
If you want to perform queries on the data collected
by an event monitor that writes to a unformatted event (UE) table,
you must first extract the data from UE table using one of the two
routines provided for this purpose. The EVMON_FORMAT_UE_TO_TABLES
procedure extracts data from the UE table to create relational tables.
The EVMON_FORMAT_UE_TO_XML table function creates an XML document.
- EVMON_FORMAT_UE_TO_TABLES
- The EVMON_FORMAT_UE_TO_TABLES procedure
examines the UE table produced by an event monitor, and extracts the
data it contains into relational tables that you can query. The number
of tables produced depends on the type of event monitor; and the logical
data groups for which that event monitor collects data. Generally
speaking, the data from each logical data group is written to a separate
table. For example, the package cache event monitor collects event
data from three logical data groups: pkgcache and pkgcache_metrics,
and pkgcache_stmt_args. Thus, three tables are produced by EVMON_FORMAT_UE_TO_TABLES. Note: EVMON_FORMAT_UE_TO_TABLES does not create a table for the control logical data group.
In addition to creating relational tables from UE tables, as of version 10.1 the EVMON_FORMAT_UE_TO_TABLES procedure provides the capability to prune data from UE tables. When you use the PRUNE_UE_TABLES option for EVMON_FORMAT_UE_TO_TABLES, data that is successfully inserted into relational tables is deleted from the unformated event (UE) table.
- EVMON_FORMAT_UE_TO_XML
- The EVMON_FORMAT_UE_TO_XML table function examines the UE table
produced by an event monitor, and extracts the data it contains into
an XML document. This document can then be queried as often as needed
using pureXML®.Notes:
- This table function works similarly to the db2evmonfmt utility
when that utility is used with the -fxml option.
The differences between using EVMON_FORMAT_UE_TO_XML instead of db2evmonfmt are
as follows:
- EVMON_FORMAT_UE_TO_XML is a table function. As such, it is invoked as part of an SQL statement. db2evmonfmt runs as a separate utility.
- EVMON_FORMAT_UE_TO_XML lets you specify a SELECT statement with a WHERE clause to filter events from the UE table. db2evmonfmt has only limited capabilities for filtering event data.
- The output XML document from EVMON_FORMAT_UE_TO_XML can be formatted by db2evmonfmt to create a flat text file.
- This table function works similarly to the db2evmonfmt utility
when that utility is used with the -fxml option.
The differences between using EVMON_FORMAT_UE_TO_XML instead of db2evmonfmt are
as follows:
With both routines, you must include a SELECT statement in the call to the routine to specify conditions for which data to extract.