The ALTER EVENT MONITOR statement alters the definition of an event monitor that has a target for the event monitor data of TABLE.
This statement can be embedded in an application program or issued interactively. It is an executable statement that can be dynamically prepared only if DYNAMICRULES run behavior is in effect for the package (SQLSTATE 42509).
>>-ALTER EVENT MONITOR--event-monitor-name----------------------> .----------------------------------------------------------------------. V (1) | >----ADD LOGICAL GROUP------evm-group--+--------------------------------+-+->< '-(--| target-table-options |--)-' target-table-options .--------------------------------------. V (2) (3) | |--------------+-TABLE--table-name------+-+---------------------| +-IN--tablespace-name----+ '-PCTDEACTIVATE--integer-'
Type of Event Monitor | evm-group Value |
---|---|
Database |
|
Tables |
|
Deadlocks |
|
Deadlocks with details |
|
Deadlocks with details history |
|
Deadlocks with details history values |
|
Table spaces |
|
Bufferpools |
|
Connections |
|
Statements |
|
Transactions |
|
Activities |
|
Statistics |
|
Threshold Violations |
|
Locking5 |
|
Package Cache5 |
|
Unit of Work5 |
|
Change History |
|
1 Logical data groups dbheader (conn_time element only), start and overflow, are all written to the CONTROL group. The overflow group is written if the event monitor is non-blocked and events were discarded. 2 Corresponds to the DETAILED_DLCONN event. 3 Corresponds to the LOCK logical data groups that occur within each DETAILED_DLCONN event. 4 Created only for partitioned database environments. 5 Refers to the Formatted Event Table version of this event monitor type. |
substring(evm-group CONCAT '_'
CONCAT event-monitor-name,1,128)
When specifying the table space name for an activities, locking, package cache, or unit of work event monitor, the table space's page size affects the INLINE LOB lengths used. Therefore, consider specifying a table space with as large a page size as possible to improve the INSERT performance of the event monitor.
The event monitor ACT is missing the ACTIVITYMETRICS group. Alter the event monitor to add this group and give the table the name "ACTMETRICS".
ALTER EVENT MONITOR ACT
ADD LOGICAL GROUP ACTIVITYMETRICS TABLE ACTMETRICS