Information written to XML for a locking event monitor

db2_lock_event

The main schema that describes a lock timeout, lock wait or deadlock event in details.

Element content: ( ( db2_deadlock_graph {zero or one times (?)} , db2_participant {one or more (+)} ) | ( db2_message , db2_event_file ) )

Attributes:

db2_deadlock_graph

Schema element represents the DB2® Deadlock Graph. The graph outlines all the participants involved in the deadlock.

Contained by:db2_lock_event

Element content: ( db2_participant {one or more (+)} )

Attributes:

db2_participant

Schema element represents the application information of the all the participants involved in a lock event.

Contained by:db2_lock_event db2_deadlock_graph

Element content: ( db2_object_requested {zero or one times (?)} , db2_app_details , db2_activity {zero or more (*)} )

Attributes:

db2_message

Error message

Contained by: db2_lock_event

db2_event_file

Fully qualified path to file where event has been written.

Contained by: db2_lock_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_app_details

appl_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_app_details

appl_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_app_details

auth_id

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

Contained by: db2_app_details

agent_tid

The unique identifier for the engine dispatchable unit (EDU) for the agent. See monitor element agent_pid - Engine dispatchable unit (EDU) identifier monitor element for more details.

Contained by:db2_app_details

Element content:

coord_agent_tid

The engine dispatchable unit (EDU) identifier of the coordinator agent for the application. See monitor element coord_agent_pid - Coordinator agent identifier monitor element for more details.

Contained by: db2_app_details

Element content:

agent_status

The status of the application that was in effect before entering lock wait status rather than the current lock wait status. See monitor element appl_status - Application Status monitor element for more details.

Contained by:db2_app_details

Attributes:

appl_action

The action/request that the client application is performing.

Contained by:db2_app_details

Attributes:

lock_timeout_val

The database configuration parameter lock timeout. Value in seconds. See monitor element lock_timeout_val - Lock timeout value monitor element for more details.

Contained by:db2_app_details

Element content:

lock_wait_val

The lock wait parameter in effect during the lock event. This is either the database configuration parameter mon_lw_thresh or the COLLECT LOCK WAIT DATA setting specified at the workload level. Value in milliseconds.

Contained by: db2_app_details

Element content:

tentry_state

TEntry state. Internal use only.

Contained by: db2_app_details

Attributes:

tentry_flag1

TEntry flags1. Internal use only.

Contained by: db2_app_details

tentry_flag2

TEntry flags2. Internal use only.

Contained by: db2_app_details

xid

XID - Global transaction identifier

Contained by: db2_app_details

workload_id

ID of the workload to which this application belongs. See monitor element workload_id - Workload ID monitor element for more details.

Contained by: db2_app_details

workload_name

Name of the workload to which this application belongs. See monitor element workload_name - Workload name monitor element for more details.

Contained by: db2_app_details

service_class_id

ID of the service subclass to which this application belongs. See monitor element service_class_id - Service class ID monitor element for more details.

Contained by: db2_app_details

service_subclass_name

Name of the service subclass to which this application belongs. See monitor element service_subclass_name - Service subclass name monitor element for more details.

Contained by: db2_app_details

current_request

The operation currently being processed or most recently processed.

Contained by:db2_app_details

lock_escalation

Indicates whether a lock request was made as part of a lock escalation. See monitor element lock_escalation - Lock escalation monitor element for more details. Possible values: Yes or No.

Contained by: db2_app_details

past_activities_wrapped

Indicates whether the activities list has wrapped. The default limit on the number of past activities to be kept by any one application is 250. This default can be overridden using the registry variable DB2_MAX_INACT_STMTS. Users may want to choose a different value for the limit to increase or reduce the amount of system monitor heap used for inactive statement information.

Contained by: db2_app_details

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_app_details

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_app_details

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_app_details

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_app_details

db2_object_requested

Schema element represents the DB2 lock that the Requestor is attempting to acquire, which is being held by the Owner.

Contained by: db2_participant

Element content: ( ( lock_name , lock_object_type , lock_specifics , lock_attributes , lock_current_mode , lock_mode_requested , lock_mode , lock_count , lock_hold_count , lock_rriid , lock_status , lock_release_flags , tablespace_name , table_name , table_schema , lock_object_type_id , lock_wait_start_time , lock_wait_end_time , ANY content ( skip ) {zero or more (*)} ) | ( threshold_name , threshold_id , queued_agents , queue_start_time , ANY content ( skip ) {zero or more (*)} ) )

Attributes:

db2_app_details

Schema element represents the details regarding this participant.

Contained by: db2_participant

Element content: ( application_handle , appl_id , appl_name , auth_id , agent_tid , coord_agent_tid , agent_status , appl_action , lock_timeout_val , lock_wait_val , tentry_state , tentry_flag1 , tentry_flag2 , xid , workload_id , workload_name , service_class_id , service_subclass_name , current_request , lock_escalation , past_activities_wrapped , client_userid , client_wrkstnname , client_applname , client_acctng , ANY content ( skip ) {zero or more (*)} )

db2_activity

List of all DB2 activities the application is currently executing or has executed.

Contained by: db2_participant

Element content: ( db2_activity_details , db2_input_variable {zero or more (*)} )

Attributes:

lock_name

Internal binary lock name. This element serves as a unique identifier for locks. See monitor element lock_name - Lock name monitor element for more details.

Contained by: db2_object_requested

lock_object_type

The type of object the application is waiting to obtain a lock. See monitor element lock_object_type - Lock object type waited on monitor element for more details.

Contained by: db2_object_requested

Attributes:

lock_specifics

Internal specifics about the lock. For information use only.

Contained by: db2_object_requested

lock_attributes

Lock attributes. See monitor element lock_attributes - Lock attributes monitor element for more details.

Contained by: db2_object_requested

lock_current_mode

Original lock before conversion. See monitor element lock_current_mode - Original lock mode before conversion monitor element for more details.

Contained by:db2_object_requested

Attributes:

lock_mode_requested

The lock mode being requested by this participant. See monitor element lock_mode_requested - Lock mode requested monitor element for more details.

Contained by:db2_object_requested

Attributes:

lock_mode

The type of lock being held. See monitor element lock_mode - Lock mode monitor element for more details.

Contained by:db2_object_requested

Attributes:

lock_count

The number of locks on the lock being held. See monitor element lock_count - Lock count monitor element for more details.

Contained by:db2_object_requested

Element content:

lock_hold_count

The number of holds placed on the lock. See monitor element lock_hold_count - Lock hold count monitor element for more details.

Contained by: db2_object_requested

Element content:

lock_rriid

IID for Row locking. Internal use only.

Contained by: db2_object_requested

Element content:

lock_status

Indicates the internal status of the lock. See monitor element lock_status - Lock status monitor element for more details.

Contained by: db2_object_requested

Attributes:

lock_release_flags

Lock release flags. See monitor element lock_release_flags - Lock release flags monitor element for more details.

Contained by: db2_object_requested

tablespace_name

The name of the table space where the lock is held. See monitor element tablespace_name - Table space name monitor element for more details.

Contained by: db2_object_requested

Attributes:

table_name

The name of the table where the lock is held. See monitor element table_name - Table name monitor element for more details.

Contained by: db2_object_requested

Attributes:

table_schema

The schema of the table. See monitor element table_schema - Table schema name monitor element for more details.

Contained by: db2_object_requested

lock_object_type_id

The type of object the application is waiting to obtain a lock. See monitor element lock_object_type - Lock object type waited on monitor element for more details.

Contained by: db2_object_requested

lock_wait_start_time

The data and time the application started waiting to obtain a lock on the object that is currently locked by the lock owner. See monitor element lock_wait_start_time - Lock wait start timestamp monitor element for more details.

Contained by: db2_object_requested

Element content:

lock_wait_end_time

The data and time the application stopped waiting to obtain a lock on the object that is currently locked by the lock owner.

Contained by: db2_object_requested

Element content:

threshold_name

The name of the threshold queue.

Contained by: db2_object_requested

threshold_id

The ID of the threshold queue.

Contained by: db2_object_requested

queued_agents

The total number of agents currently queued in the threshold.

Contained by: db2_object_requested

Element content:

queue_start_time

The data and time the application started waiting in the queue to obtain a threshold ticket.

Contained by: db2_object_requested

Element content:

db2_participant

Schema element represents a single stack entry in a deadlock graph.

Contained by: db2_lock_event db2_deadlock_graph

Attributes:

activity_id

Counter which uniquely identifies an activity for an application within a given unit of work. See monitor element activity_id - Activity ID monitor element for more details.

Contained by: db2_activity_details

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_activity_details

package_name

The name of the package that contains the SQL statement currently executing. See monitor element package_name - Package name monitor element for more details.

Contained by: db2_activity_details

package_schema

The schema name of the package associated with an SQL statement. See monitor element package_schema - Package schema monitor element for more details.

Contained by: db2_activity_details

package_version_id

The package version identifies the version identifier of the package that contains the SQL statement currently executing. See monitor element package_version_id - Package version monitor element for more details.

Contained by: db2_activity_details

consistency_token

The package consistency token helps to identify the version of the package that contains the SQL statement currently executing. See monitor element consistency_token - Package consistency token monitor element for more details.

Contained by: db2_activity_details

section_number

The internal section number in the package for the SQL statement currently processing or most recently processed. See monitor element section_number - Section number monitor element for more details.

Contained by: db2_activity_details

Element content:

reopt

The REOPT bind option used to precompile this package. Possible values are: NONE, ONCE, and ALWAYS. See the REOPT bind options for more details.

Contained by: db2_activity_details

incremental_bind

The package was incrementally bound at execution time. Possible values: Yes or No.

Contained by: db2_activity_details

effective_isolation

The isolation value in effect for the SQL statement while it was being run. See monitor element effective_isolation - Effective isolation monitor element for more details.

Contained by: db2_activity_details

Attributes:

effective_query_degree

The degree value in effect for the SQL statement while it was being run. See monitor element effective_query_degree - Effective query degree monitor element for more details.

Contained by: db2_activity_details

Element content:

stmt_unicode

The SQL statement Unicode flag. Possible values: Yes or No.

Contained by:db2_activity_details

stmt_lock_timeout

The locktimeout value in effect for the SQL statement while it was being run. See monitor element stmt_lock_timeout - Statement lock timeout monitor element for more details.

Contained by: db2_activity_details

Element content:

stmt_type

The type of SQL statement processed. Possible values: Dynamic or Static. See monitor element stmt_type - Statement type monitor element for more details.

Contained by: db2_activity_details

Attributes:

stmt_operation

See monitor element stmt_operation/operation - Statement operation monitor element for more details.

Contained by: db2_activity_details

stmt_query_id

Internal query identifier given to any SQL statement. See monitor element stmt_query_id - Statement query identifier monitor element for more details.

Contained by: db2_activity_details

Element content:

stmt_nest_level

This element shows the level of nesting or recursion in effect when the statement was run. See monitor element stmt_nest_level - Statement nesting level monitor element for more details.

Contained by: db2_activity_details

Element content:

stmt_invocation_id

This element shows the identifier of the routine invocation in which the SQL statement was run. See monitor element stmt_invocation_id - Statement invocation identifier monitor element for more details.

Contained by: db2_activity_details

Element content:

stmt_source_id

This element shows the internal identifier given to the source of the SQL statement that was run. See monitor element stmt_source_id - Statement source identifier monitor element for more details.

Contained by: db2_activity_details

Element content:

stmt_pkgcache_id

This element shows the internal package cache identifier of a dynamic SQL statement. See monitor element stmt_pkgcache_id - Statement package cache identifier monitor element for more details.

Contained by: db2_activity_details

Element content:

stmt_text

The text of the SQL statement. See monitor element stmt_text - SQL statement text monitor element for more details.

Contained by: db2_activity_details

stmt_first_use_time

This element shows the first time the statement entry was processed. For cursor operations, stmt_first_use_time - Statement first use timestamp monitor element shows when the cursor was opened. At application coordination nodes, this value reflects the application requests; at non-coordinator nodes, this value reflects when requests were received from the originating node. See monitor element stmt_first_use_time for more details.

Contained by: db2_activity_details

Element content:

stmt_last_use_time

This element shows the last time the statement entry was processed. For cursor operations, stmt_last_use_time - Statement last use timestamp monitor element shows the time of the last action on the cursor where that action could be an open, fetch, or close. At application coordination nodes, this value reflects the application requests; at non-coordinator nodes, this value reflects when requests were received from the originating node. See monitor element stmt_last_use_time for more details.

Contained by: db2_activity_details

Element content:

db2_activity_details

Schema represents the details regarding this activity.

Contained by: db2_activity

Element content: ( activity_id , uow_id , package_name , package_schema , package_version_id , consistency_token , section_number , reopt , incremental_bind , effective_isolation , effective_query_degree , stmt_unicode , stmt_lock_timeout , stmt_type , stmt_operation , stmt_query_id , stmt_nest_level , stmt_invocation_id , stmt_source_id , stmt_pkgcache_id , stmt_text , stmt_first_use_time , stmt_last_use_time , ANY content ( skip ) {zero or more (*)} )

db2_input_variable

Schema element represents the list of input variables associated with the SQL statement.

Contained by: db2_activity

Element content: ( stmt_value_index , stmt_value_isreopt , stmt_value_isnull , stmt_value_type , stmt_value_data , ANY content ( skip ) {zero or more (*)} )

stmt_value_index

The element represents the position of the input parameter marker or host variable used in the SQL statement. See monitor element stmt_value_index - Value index monitor element for more details.

Contained by: db2_input_variable

stmt_value_isreopt

The element shows whether the variable was used during statement reoptimization. See monitor element stmt_value_isreopt - Variable used for statement reoptimization monitor element for more details.

Contained by: db2_input_variable

Attributes:

stmt_value_isnull

The element shows whether a data value associated with the SQL statement is the NULL value. See monitor element stmt_value_isnull - Value has null value monitor element for more details.

Contained by: db2_input_variable

Attributes:

stmt_value_type

The element contains a string representation of the type of data value associated with an SQL statement. See monitor element stmt_value_type - Value type monitor element for more details.

Contained by:db2_input_variable

stmt_value_data

The element contains a string representation of a data value associated with an SQL statement. See monitor element stmt_value_data - Value data monitor element for more details.

Contained by: db2_input_variable