Information written to XML by EVMON_FORMAT_UE_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:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:long | required | |||
type | required | ||||
timestamp | xs:dateTime | required | |||
member | required | ||||
release | xs:long | required | |||
ANY attribute from ANY namespace |
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:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
dl_conns | xs:int | required | |||
rolled_back_participant_no | xs:int | required | |||
type | required | ||||
ANY attribute from ANY namespace |
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:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
no | xs:int | required | |||
type | required | ||||
participant_no_holding_lk | xs:int | optional | |||
deadlock_member | xs:int | optional | |||
ANY attribute from ANY namespace |
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 elementfor 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 elementfor 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 elementfor 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 elementfor more details.
Contained by: db2_app_details
agent_tid
Contained by: db2_app_details
Element content:
Type | Facet |
---|---|
xs:long |
coord_agent_tid
Contained by: db2_app_details
Element content:
Type | Facet |
---|---|
xs:long |
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:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:int | optional |
appl_action
The action/request that the client application is performing
Contained by: db2_app_details
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:int | optional |
lock_timeout_val
The database configuration parameter lock timeout. Value in seconds. See monitor element lock_timeout_val - Lock timeout value monitor elementfor more details.
Contained by: db2_app_details
Element content:
Type | Facet |
---|---|
xs:long |
lock_wait_val
The lock wait parameter in effect during the lock event. This is either the database configuration parameter MON_LKWAIT_THRSH or the COLLECT LOCK WAIT DATA setting specified at the workload level. Value in milliseconds.
Contained by: db2_app_details
Element content:
Type | Facet |
---|---|
xs:long |
tentry_state
TEntry state. Internal use only.
Contained by: db2_app_details
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:int | optional |
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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor more details.
Contained by: db2_app_details
utility_invocation_id
Contained by: db2_app_details
service_superclass_name
Name of the service superclass to which this application belongs. See monitor element service_superclass_name - Service superclass name monitor elementfor 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:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
type | required |
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 , utility_invocation_id , service_superclass_name , 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:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
type | required | ||||
ANY attribute from ANY namespace |
lock_name
Internal binary lock name. This element serves as a unique identifier for locks. See monitor element lock_name - Lock name monitor elementfor 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 elementfor more details.
Contained by: db2_object_requested
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:long | optional |
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 elementfor more details.
Contained by: db2_object_requested
lock_current_mode
Orginal lock before conversion. See monitor element lock_current_mode - Original lock mode before conversion monitor elementfor more details.
Contained by: db2_object_requested
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:long | optional | |||
mode | optional |
lock_mode_requested
The lock mode being requested by this participant. See monitor element lock_mode_requested - Lock mode requested monitor elementfor more details.
Contained by: db2_object_requested
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:long | optional | |||
mode | optional |
lock_mode
The type of lock being held. See monitor element lock_mode - Lock mode monitor elementfor more details.
Contained by: db2_object_requested
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:long | optional | |||
mode | optional |
lock_count
The number of locks on the lock being held. See monitor element lock_count - Lock count monitor elementfor more details.
Contained by: db2_object_requested
Element content:
Type | Facet |
---|---|
xs:long |
lock_hold_count
The number of holds placed on the lock. See monitor element lock_hold_count - Lock hold count monitor elementfor more details.
Contained by: db2_object_requested
Element content:
Type | Facet |
---|---|
xs:long |
lock_rriid
IID for Row locking. Internal use only.
Contained by: db2_object_requested
Element content:
Type | Facet |
---|---|
xs:long |
lock_status
Indicates the internal status of the lock. See monitor element lock_status - Lock status monitor elementfor more details.
Contained by: db2_object_requested
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:int | optional |
lock_release_flags
Lock release flags. See monitor element lock_release_flags - Lock release flags monitor elementfor 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 elementfor more details.
Contained by: db2_object_requested
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:long | optional |
table_name
The name of the table where the lock is held. See monitor element table_name - Table name monitor elementfor more details.
Contained by: db2_object_requested
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:long | optional | |||
data_member_id | optional | The identifier of the data member for which information is returned. |
table_schema
The schema of the table. See monitor element table_schema - Table schema name monitor elementfor 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 elementfor 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 elementfor more details.
Contained by: db2_object_requested
Element content:
Type | Facet |
---|---|
xs:dateTime |
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:
Type | Facet |
---|---|
xs:dateTime |
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:
Type | Facet |
---|---|
xs:long |
queue_start_time
The data and time the application started waiting in the queue to to obtain a threshold ticket.
Contained by: db2_object_requested
Element content:
Type | Facet |
---|---|
xs:dateTime |
db2_participant
Schema element represents a single stack entry in a deadlock graph.
Contained by: db2_lock_event db2_deadlock_graph
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
no | xs:int | required | |||
deadlock_member | required | ||||
participant_no_holding_lk | xs:int | required | |||
application_handle | required | ||||
ANY attribute from ANY namespace |
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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor more details.
Contained by: db2_activity_details
Element content:
Type | Facet |
---|---|
xs:long |
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 elementfor more details.
Contained by: db2_activity_details
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:long | optional |
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 elementfor more details.
Contained by: db2_activity_details
Element content:
Type | Facet |
---|---|
xs:long |
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 elementfor more details
Contained by: db2_activity_details
Element content:
Type | Facet |
---|---|
xs:int |
stmt_type
The type of SQL statement processed. Possible values: Dynamic or Static. See monitor element stmt_type - Statement type monitor elementfor more details.
Contained by: db2_activity_details
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:long | required |
stmt_operation
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 elementfor more details.
Contained by: db2_activity_details
Element content:
Type | Facet |
---|---|
xs:long |
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 elementfor more details.
Contained by: db2_activity_details
Element content:
Type | Facet |
---|---|
xs:long |
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 elementfor more details.
Contained by: db2_activity_details
Element content:
Type | Facet |
---|---|
xs:long |
stmt_source_id
This element shows the internal identifier given to the source of the the SQL statement that was run. See monitor element stmt_source_id - Statement source identifier monitor elementfor more details.
Contained by: db2_activity_details
Element content:
Type | Facet |
---|---|
xs:long |
stmt_pkgcache_id
This element shows the internal package cahce identifier of a dynamic SQL statement. See monitor element stmt_pkg_cache_id - Statement package cache identifier monitor elementfor more details.
Contained by: db2_activity_details
Element content:
Type | Facet |
---|---|
xs:long |
stmt_text
The text of the SQL statement. See monitor element stmt_text - SQL statement text monitor elementfor 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 elementshows 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:
Type | Facet |
---|---|
xs:dateTime |
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 elementshows 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:
Type | Facet |
---|---|
xs:dateTime |
query_actual_degree
The actual runtime degree value for the SQL statement while it was being run. See monitor element query_actual_degree - Actual runtime degree of intrapartition parallelism monitor elementfor more details.
Contained by: db2_activity_details
Element content:
Type | Facet |
---|---|
xs:int |
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 , query_actual_degree , 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 elementfor 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 elementfor more details.
Contained by: db2_input_variable
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:int | required |
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 elementfor more details.
Contained by: db2_input_variable
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:int | required |
stmt_value_type
stmt_value_type - Value type monitor element
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 elementfor more details.
Contained by: db2_input_variable