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

Attributes:

package_id

See monitor element package_id for more details.

Contained by: package_entry

Element content:

package_elapsed_time

See monitor element package_elapsed_time for more details.

Contained by: package_entry

Element content:

invocation_id

See monitor element invocation_id for more details.

Contained by: package_entry

Element content:

routine_id

See monitor element routine_id for more details.

Contained by: package_entry

Element content:

nesting_level

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

Contained by: package_list

Element content:

package_list_exceeded

See monitor element package_list_exceeded for more information.

Contained by: package_list

package_list_entries

Contained by: package_list

Element content: ( package_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 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 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 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 for more details.

Contained by: db2_uow_event

application_handle

A system-wide unique ID for the application. See monitor element agent_id 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 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 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 for more details.

Contained by: db2_uow_event

coord_member

See monitor element coord_member for more details.

Contained by: db2_uow_event

member_activation_time

The time this database member was activated. See monitor element db_conn_time 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 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 for more details.

Contained by: db2_uow_event

service_superclass_name

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

Contained by: db2_uow_event

service_subclass_name

The name of the service sub class under which the unit of work completed. See monitor element service_subclass_name 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 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 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 for more details.

Contained by: db2_uow_event

client_pid

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

Contained by: db2_uow_event

Element content:

client_product_id

The product ID of the client. See monitor element client_prdid for more details.

Contained by: db2_uow_event

client_platform

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

Contained by: db2_uow_event

Attributes:

client_protocol

The product ID of the client. See monitor element client_protocol 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 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 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 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 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

Element content: ( wlm_queue_time_total , wlm_queue_assignments_total , fcm_tq_recv_wait_time , fcm_message_recv_wait_time , fcm_tq_send_wait_time , fcm_message_send_wait_time , agent_wait_time , agent_waits_total , lock_wait_time , lock_waits , direct_read_time , direct_read_reqs , direct_write_time , direct_write_reqs , log_buffer_wait_time , num_log_buffer_full , log_disk_wait_time , log_disk_waits_total , tcpip_recv_wait_time , tcpip_recvs_total , client_idle_wait_time , ipc_recv_wait_time , ipc_recvs_total , ipc_send_wait_time , ipc_sends_total , tcpip_send_wait_time , tcpip_sends_total , pool_write_time , pool_read_time , audit_file_write_wait_time , audit_file_writes_total , audit_subsystem_wait_time , audit_subsystem_waits_total , diaglog_write_wait_time , diaglog_writes_total , fcm_send_wait_time , fcm_recv_wait_time , total_wait_time , total_rqst_time , rqsts_completed_total , total_app_rqst_time , app_rqsts_completed_total , total_section_sort_proc_time , total_section_sort_time , total_section_sorts , rows_read , rows_modified , pool_data_l_reads , pool_index_l_reads , pool_temp_data_l_reads , pool_temp_index_l_reads , pool_xda_l_reads , pool_temp_xda_l_reads , total_cpu_time , act_completed_total , pool_data_p_reads , pool_temp_data_p_reads , pool_xda_p_reads , pool_temp_xda_p_reads , pool_index_p_reads , pool_temp_index_p_reads , pool_data_writes , pool_xda_writes , pool_index_writes , direct_reads , direct_writes , rows_returned , deadlocks , lock_timeouts , lock_escals , fcm_sends_total , fcm_recvs_total , fcm_send_volume , fcm_recv_volume , fcm_message_sends_total , fcm_message_recvs_total , fcm_message_send_volume , fcm_message_recv_volume , fcm_tq_sends_total , fcm_tq_recvs_total , fcm_tq_send_volume , fcm_tq_recv_volume , tq_tot_send_spills , tcpip_send_volume , tcpip_recv_volume , ipc_send_volume , ipc_recv_volume , post_threshold_sorts , post_shrthreshold_sorts , sort_overflows , audit_events_total , total_rqst_mapped_in {zero or one times (?)} , total_rqst_mapped_out {zero or one times (?)} , act_rejected_total , act_aborted_total , total_sorts , total_routine_time , total_compile_proc_time , total_compile_time , total_compilations , total_implicit_compile_proc_time , total_implicit_compile_time , total_implicit_compilations , total_runstats_proc_time , total_runstats_time , total_runstats , total_reorg_proc_time , total_reorg_time , total_reorgs , total_load_proc_time , total_load_time , total_loads , total_section_proc_time , total_section_time , total_app_section_executions , total_commit_proc_time , total_commit_time , total_app_commits , total_rollback_proc_time , total_rollback_time , total_app_rollbacks , total_routine_user_code_proc_time , total_routine_user_code_time , thresh_violations , num_lw_thresh_exceeded , total_routine_invocations , int_commits , int_rollbacks , cat_cache_inserts , cat_cache_lookups , pkg_cache_inserts , pkg_cache_lookups , act_rqsts_total , total_act_wait_time , total_act_time , ANY content ( skip ) {zero or more (*)} )

Attributes:

client_hostname

The host name of the client. See monitor element client_hostname for more details.

Contained by: db2_uow_event

client_port_number

The port number of the client. See monitor element client_port_number 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 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: