Home » Tables » Call Evmon_Format_Ue_To_Tables

Call Evmon_Format_Ue_To_Tables

Unless you specify otherwise, the default version of the XML schema file for the current release is used when you call the EVMON_FORMAT_UE_TO_TABLES procedure.

So, if you upgrade to a new release of the DB2 product, then, by default, the new version of #, IC75525: EVMON_FORMAT_UE_TO_TABLES DOES NOT OUTPUT ANYTHING IF PARTIAL EVENT EXISTS.

Fixes are available.

DB2 Version 9.

7 Fix Pack 5 for Linux, UNIX, and Windows DB2 Version 9.

7 Fix Pack 6 for Linux,.

, $ 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 call EVMON_FORMAT_UE_TO_TABLES ( ‘UOW’, NULL, NULL, NULL, NULL, NULL, NULL.

, call evmon_format_ue_to_tables (‘pkgcache’, null, null, null, null, null, null, -1, ‘select * from expensivestmts’) This procedure examines the UE table TRACKSTMTS produced by the event monitor.

It selects all of the records from the UE table, and from them, creates two relational tables from the data collected by the package cache event monitor:, 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 #, 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.

, The Information Management Specialists Consider # Insert Time Clustered Tables #Rows clustered by insert time #Very predominant usage pattern: rows inserted together are often deleted together #Results in many extents naturally becoming empty after deletions #ITC tables cluster data by using a virtual column which clusters rows that are inserted at similar, 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.

, 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.

, Any new columns or tables that might have been added in the fix pack are not reflected in the output of the EVMON_FORMAT_UE_TO_TABLES procedure.

For release upgrades.

Unless you specify otherwise, the default version of the XML schema file for the current release is used when you call the EVMON_FORMAT_UE_TO_TABLES procedure.

call evmon_format_ue_to_tables