Home » Tables » Db2 Evmon_Format_Ue_To_Tables

Db2 Evmon_Format_Ue_To_Tables

The EVMON_FORMAT_UE_TO_TABLES procedure retrieves data stored in an unformatted event (UE) table produced by an event monitor and converts it into a set of relational tables.

EVMON_FORMAT_UE_TO_TABLES procedure – move an XML document to relational tables – IBM DB2 9.

7 for Linux, UNIX, and Windows, The data in the BLOB column is not in a readable format and requires conversion, through use of the db2evmonfmt Java-based tool, EVMON_FORMAT_UE_TO_XML table function, or EVMON_FORMAT_UE_TO_TABLES procedure, into a consumable format such as an XML document or a relational table.

target-table-options Identifies options for the target table.

, 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 #, As of DB2 V10.

1 EVMON_FORMAT_UE_TO_TABLES procedure supports a new option: UPGRADE_TABLES.

When you run the EVMON_FORMAT_UE_TO_TABLES procedure with this option, any existing tables produced by the procedure are altered so that the table columns match the output produced by the new version of EVMON_FORMAT_UE_TO_TABLES procedure.

, $ db2 -stvf session1.

sh call EVMON_FORMAT_UE_TO_TABLES ( ‘UOW’, NULL, NULL, NULL, NULL, NULL, NULL, 10000, ‘SELECT * FROM EVMON.

UOWEVENTS WHERE event_timestamp > ”2011-07-01-17.

53.

00.

000000” and event_timestamp db2 -stvf session2.

sh call EVMON_FORMAT_UE_TO_TABLES ( ‘UOW’, NULL, NULL, NULL, NULL, NULL, NULL.

, DB2 Version 9.

7 for Linux, UNIX, and Windows EVMON_FORMAT_UE_TO_XML table function – convert unformatted events to XML The EVMON_FORMAT_UE_TO_XML table function extracts binary events from an unformatted event table and formats them into an XML document.

, DB2 whether you had moved it all there yet or not.

In addition, D2s load from cursor can quickly populate the new D2 database tables from the Oracle data.

#Restricted use Q-replication functionality to replicate DB2 LUW to 2 DB2 LUW servers for Active-Active environments with DB2 AESE, 23/01/2012 > db2 “call EVMON_FORMAT_UE_TO_TABLES (‘LOCKING’, NULL, NULL, NULL, ‘DBA’, NULL, NULL, -1, ‘SELECT * FROM DBA.

MY_LOCKS ORDER BY event_timestamp’)” Return Status = 0.

If you receive this error: SQL0171N The data type, length or value of the argument for the parameter in position “3 (query) ” of routine “XDB_DECOMP_XML_FROM_QUERY” is incorrect.

, DB6LW_PARTICIPANT is an SAP Structure so does not store data like a database table does but can be used to process “DB6: EVMON_FORMAT_UE_TO_TABLES participant” Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or #, 23/01/2012 > db2 “call EVMON_FORMAT_UE_TO_TABLES (‘LOCKING’, NULL, NULL, NULL, ‘DBA’, NULL, NULL, -1, ‘SELECT * FROM DBA.

MY_LOCKS ORDER BY event_timestamp’)” Return Status = 0.

If you receive this error: SQL0171N The data type, length or value of the argument for the parameter in position “3 (query) ” of routine “XDB_DECOMP_XML_FROM_QUERY” is incorrect.

db2 evmon_format_ue_to_tables