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 , ANY content ( skip ) {zero or more (*)} )

Attributes:

package_id

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

Contained by: package_entry

Element content:

package_elapsed_time

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

Contained by: package_entry

Element content:

invocation_id

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

Contained by: package_entry

Element content:

routine_id

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

Contained by: package_entry

Element content:

nesting_level

See monitor element nesting_level - Nesting level monitor elementfor 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

Contained by: package_list

Element content:

package_list_exceeded

See monitor element package_list_exceeded - Package list exceeded monitor elementfor 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 elementfor more details.

Contained by: executable_entry

num_executions

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

Contained by: executable_entry

Element content:

rows_read

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

Contained by: executable_entry

Element content:

total_cpu_time

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

Contained by: executable_entry

Element content:

total_act_time

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

Contained by: executable_entry

Element content:

total_act_wait_time

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

Contained by: executable_entry

Element content:

lock_wait_time

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

Contained by: executable_entry

Element content:

lock_waits

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

Contained by: executable_entry

Element content:

total_sorts

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

Contained by: executable_entry

Element content:

post_threshold_sorts

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

Contained by: executable_entry

Element content:

post_shrthreshold_sorts

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

Contained by: executable_entry

Element content:

sort_overflows

See monitor element sort_overflows - Sort overflows monitor elementfor 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

Contained by: executable_list

Element content:

executable_list_truncated

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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor more details.

Contained by: db2_uow_event

client_platform

The platform of the client. See monitor element client_platform - Client operating platform monitor elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 intrapartition parallelism state of the unit of work. Possible values are YES and NO.

Contained by: db2_uow_event