Information written to XML by EVMON_FORMAT_UE_TO_XML for a unit of work event monitor

db2_uow_event

The main schema that describes a unit of work event.

Element content: ( completion_status , start_time , stop_time , connection_time , application_name , application_handle , application_id , uow_id , workload_occurrence_id , coord_member , member_activation_time , workload_name , workload_id , service_superclass_name {zero or one times (?)} , service_subclass_name {zero or one times (?)} , service_class_id {zero or one times (?)} , session_authid {zero or one times (?)} , system_authid , client_pid , client_product_id , client_platform , client_protocol {zero or one times (?)} , client_userid {zero or one times (?)} , client_wrkstnname {zero or one times (?)} , client_applname {zero or one times (?)} , client_acctng {zero or one times (?)} , local_transaction_id , global_transaction_id , system_metrics , client_hostname , client_port_number , uow_log_space_used , package_list , executable_list , intra_parallel_state , member_subset_id , active_hash_grpbys_top , active_hash_joins_top , active_olap_funcs_top , active_peas_top , active_peds_top , active_sort_consumers_top , active_sorts_top , active_col_vector_consumers_top , sort_consumer_heap_top , sort_consumer_shrheap_top , sort_heap_top , sort_shrheap_top , ANY content ( skip ) {zero or more (*)} )

Attributes:

package_id

See monitor element package_id - Package identifier monitor element for more details.

Contained by: package_entry

Element content:

package_elapsed_time

See monitor element package_elapsed_time - Package elapsed time monitor element for more details.

Contained by: package_entry

Element content:

invocation_id

See monitor element invocation_id - Invocation ID monitor element for more details.

Contained by: package_entry

Element content:

routine_id

See monitor element routine_id - Routine ID monitor element for more details.

Contained by: package_entry

Element content:

nesting_level

See monitor element nesting_level - Nesting level monitor element for more details.

Contained by: package_entry

Element content:

package_entry

Contained by: package_list_entries

Element content: ( package_id , package_elapsed_time , invocation_id , routine_id , nesting_level , ANY content ( skip ) {zero or more (*)} )

Attributes:

package_list_size

See monitor element package_list_size - Size of package list monitor element for more details.

Contained by: package_list

Element content:

package_list_exceeded

See monitor element package_list_exceeded - Package list exceeded monitor element for more details.

Contained by: package_list

package_list_entries

Contained by: package_list

Element content: ( package_entry {zero or more (*)} )

Attributes:

executable_id

See monitor element executable_id - Executable ID monitor element for more details.

Contained by: executable_entry

num_executions

See monitor element num_executions - Statement executions monitor element for more details.

Contained by: executable_entry

Element content:

rows_read

See monitor element rows_read - Rows read monitor element for more details.

Contained by: executable_entry

Element content:

total_cpu_time

See monitor element total_cpu_time - Total CPU time monitor element for more details.

Contained by: executable_entry

Element content:

total_act_time

See monitor element total_act_time - Total activity time monitor element for more details.

Contained by: executable_entry

Element content:

total_act_wait_time

See monitor element total_act_wait_time - Total activity wait time monitor element for more details.

Contained by: executable_entry

Element content:

lock_wait_time

See monitor element lock_wait_time - Time waited on locks monitor element for more details.

Contained by: executable_entry

Element content:

lock_waits

See monitor element lock_waits - Lock waits monitor element for more details.

Contained by: executable_entry

Element content:

total_sorts

See monitor element total_sorts - Total sorts monitor element for more details.

Contained by: executable_entry

Element content:

post_threshold_sorts

See monitor element post_threshold_sorts - Post threshold sorts monitor element for more details.

Contained by: executable_entry

Element content:

post_shrthreshold_sorts

See monitor element post_shrthreshold_sorts - Post shared threshold sorts monitor element for more details.

Contained by: executable_entry

Element content:

sort_overflows

See monitor element sort_overflows - Sort overflows monitor element for more details.

Contained by: executable_entry

Element content:

executable_entry

Contained by: executable_list_entries

Element content: ( executable_id , num_executions , rows_read , total_cpu_time , total_act_time , total_act_wait_time , lock_wait_time , lock_waits , total_sorts , post_threshold_sorts , post_shrthreshold_sorts , sort_overflows , ANY content ( skip ) {zero or more (*)} )

Attributes:

executable_list_size

See monitor element executable_list_size - Size of executable list monitor element for more details.

Contained by: executable_list

Element content:

executable_list_truncated

See monitor element executable_list_truncated - Executable list truncated monitor element for more details.

Contained by: executable_list

executable_list_entries

Contained by: executable_list

Element content: ( executable_entry {zero or more (*)} )

Attributes:

completion_status

The completion status of the unit of work. Possible values are: UNKNOWN, COMMIT, ROLLBACK, GLOBAL_COMMIT, GLOBAL ROLLBACK, XA_END, XA_PREPARE

Contained by: db2_uow_event

start_time

The start time of the unit of work. See monitor element uow_start_time - Unit of work start timestamp monitor element for more details.

Contained by: db2_uow_event

Element content:

stop_time

The stop time of the unit of work. See monitor element uow_stop_time - Unit of work stop timestamp monitor element for more details.

Contained by: db2_uow_event

Element content:

connection_time

The time the application connected to the database member. See monitor element conn_time - Time of database connection monitor element for more details.

Contained by: db2_uow_event

Element content:

application_name

The name of the application running at the client, as known to the database. See monitor element appl_name - Application name monitor element for more details.

Contained by: db2_uow_event

application_handle

A system-wide unique ID for the application. See monitor element agent_id - Application handle (agent ID) monitor element for more details.

Contained by: db2_uow_event

application_id

This identifier is generated when the application connects to the database at the database manager. See monitor element appl_id - Application ID monitor element for more details.

Contained by: db2_uow_event

uow_id

The unit of work ID to which this activity record applies. See monitor element uow_id - Unit of work ID monitor element for more details.

Contained by: db2_uow_event

workload_occurrence_id

The workload occurrence ID to which this activity record applies. See monitor element workload_occurrence_id - Workload occurrence identifier monitor element for more details.

Contained by: db2_uow_event

coord_member

Contained by: db2_uow_event

member_activation_time

The time this database member was activated. See monitor element db_conn_time - Database activation timestamp monitor element for more details.

Contained by: db2_uow_event

Element content:

workload_name

The name of the workload under which the unit of work completed. See monitor element workload_name - Workload name monitor element for more details.

Contained by: db2_uow_event

workload_id

The workload ID of the workload under which the unit of work completed. See monitor element workload_id - Workload ID monitor element for more details.

Contained by: db2_uow_event

service_superclass_name

The name ofthe service super class under which the unit of work completed. See monitor element service_superclass_name - Service superclass name monitor element for more details.

Contained by: db2_uow_event

service_subclass_name

The name ofthe service sub class under which the unit of work completed. See monitor element service_subclass_name - Service subclass name monitor element for more details.

Contained by: db2_uow_event

service_class_id

The service class ID of the service class under which the unit of work completed. See monitor element service_class_id - Service class ID monitor element for more details.

Contained by: db2_uow_event

session_authid

The session authorization ID of the user who invoked the application that is being monitored. See monitor element session_auth_id - Session authorization ID monitor element for more details.

Contained by: db2_uow_event

system_authid

The system authorization ID of the user who invoked the application that is being monitored. See monitor element system_auth_id - System authorization identifier monitor element for more details.

Contained by: db2_uow_event

client_pid

The process ID reported by the client. See monitor element client_pid - Client process ID monitor element for more details.

Contained by: db2_uow_event

Element content:

client_product_id

The product ID of the client. See monitor element client_prdid - Client product and version ID monitor element for more details.

Contained by: db2_uow_event

client_platform

The platform of the client. See monitor element client_platform - Client operating platform monitor element for more details.

Contained by: db2_uow_event

Attributes:

client_protocol

The product ID of the client. See monitor element client_protocol - Client communication protocol monitor element for more details.

Contained by: db2_uow_event

client_userid

The client user ID generated by a transaction manager and provided to the server. See monitor element client_userid - Client user ID monitor element for more details.

Contained by: db2_uow_event

client_wrkstnname

Identifies the client system or workstation, if the sqleseti API was issued in this connection. See monitor element client_wrkstnname - Client workstation name monitor element for more details.

Contained by: db2_uow_event

client_applname

Identifies the server transaction program performing the transaction, if the sqleseti API was issued in this connection. See monitor element client_applname - Client application name monitor element for more details.

Contained by: db2_uow_event

client_acctng

The data passed to the target database for logging and diagnostic purposes, if the sqleseti API was issued in this connection. See monitor element client_acctng - Client accounting string monitor element for more details.

Contained by: db2_uow_event

local_transaction_id

The local transaction id for the unit of work.

Contained by: db2_uow_event

global_transaction_id

The global transaction id for the unit of work.

Contained by: db2_uow_event

system_metrics

The metrics for the unit of work.

Contained by: db2_uow_event

client_hostname

The hostname of the client. See monitor element client_hostname - Client hostname monitor element for more details.

Contained by: db2_uow_event

client_port_number

The port number of the client. See monitor element client_port_number - Client port number monitor element for more details.

Contained by: db2_uow_event

Element content:

uow_log_space_used

The amount of log space used during the unit of work. See monitor element uow_log_space_used - Unit of work log space used monitor element for more details.

Contained by: db2_uow_event

Element content:

package_list

The package list for the unit of work.

Contained by: db2_uow_event

Element content: ( package_list_size , package_list_exceeded , package_list_entries , ANY content ( skip ) {zero or more (*)} )

Attributes:

executable_list

The executable list for the unit of work.

Contained by: db2_uow_event

Element content: ( executable_list_size , executable_list_truncated , executable_list_entries , ANY content ( skip ) {zero or more (*)} )

Attributes:

intra_parallel_state

The current intra-partition parallelism state of the unit of work. Possible values are YES and NO.

Contained by: db2_uow_event

member_subset_id

The identifier of the member subset the application that ran this unit of work was assigned to. See monitor element member_subset_id - Member subset ID monitor element for more details.

Contained by: db2_uow_event

Element content:

active_hash_grpbys_top

See monitor element active_hash_grpbys_top - Active hash GROUP BY operations high watermark monitor element for more details.

Contained by: db2_uow_event

Element content:

active_hash_joins_top

See monitor element active_hash_joins_top - Active hash join operations high watermark monitor element for more details.

Contained by: db2_uow_event

Element content:

active_olap_funcs_top

See monitor element active_olap_funcs_top - Active OLAP function operations high watermark monitor element for more details.

Contained by: db2_uow_event

Element content:

active_peas_top

See monitor element active_peas_top - Active partial early aggregation operations high watermark monitor element for more details.

Contained by: db2_uow_event

Element content:

active_peds_top

See monitor element active_peds_top - Active partial early distinct operations high watermark monitor element for more details.

Contained by: db2_uow_event

Element content:

active_sort_consumers_top

See monitor element active_sort_consumers_top - Active sort memory consumers high watermark monitor element for more details.

Contained by: db2_uow_event

Element content:

active_sorts_top

See monitor element active_sorts_top - Active sorts high watermark monitor element for more details.

Contained by: db2_uow_event

Element content:

active_col_vector_consumers_top

See monitor element active_col_vector_consumers_top - Active columnar vector memory consumers high watermark monitor element for more details.

Contained by: db2_uow_event

Element content:

sort_consumer_heap_top

See monitor element sort_consumer_heap_top - Individual private sort heap consumer high watermark monitor element for more details.

Contained by: db2_uow_event

Element content:

sort_consumer_shrheap_top

See monitor element sort_consumer_shrheap_top - Individual shared sort heap consumer high watermark monitor element for more details.

Contained by: db2_uow_event

Element content:

sort_heap_top

See monitor element sort_heap_top - Sort private heap high watermark monitor element for more details.

Contained by: db2_uow_event

Element content:

sort_shrheap_top

See monitor element sort_shrheap_top - Sort share heap high watermark monitor element for more details.

Contained by: db2_uow_event

Element content: