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 | xs:string - Max length: 32 (LOCKTIMEOUT, DEADLOCK, LOCKWAIT ) | required | |||
timestamp | xs:dateTime | required | |||
member | member_type | required | |||
release | xs:long | required | |||
ANY attribute from ANY namespace |
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 | xs:string - Max length: 10 (local, global ) | required | |||
ANY attribute from ANY namespace |
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 | xs:string - Max length: 32 (Requester, Owner ) | required | |||
participant_no_holding_lk | xs:int | optional | |||
ANY attribute from ANY namespace |
Error message
Contained by: db2_lock_event
Type | Facet |
---|---|
xs:string | Max length: 1024 |
Fully qualified path to file where event has been written.
Contained by: db2_lock_event
Type | Facet |
---|---|
xs:string | Max length: 1024 |
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
Type | Facet |
---|---|
xs:long |
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
Type | Facet |
---|---|
xs:string | Max length: 128 |
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
Type | Facet |
---|---|
xs:string | Max length: 128 |
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
Type | Facet |
---|---|
xs:string | Max length: 128 |
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:
Type | Facet |
---|---|
xs:long |
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:
Type | Facet |
---|---|
xs:long |
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
Type | Facet |
---|---|
xs:string | Max length: 32 |
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:int | optional |
The action/request that the client application is performing.
Contained by:db2_app_details
Type | Facet |
---|---|
xs:string | Max length: 32 |
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:int | optional |
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:
Type | Facet |
---|---|
xs:long |
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:
Type | Facet |
---|---|
xs:long |
TEntry state. Internal use only.
Contained by: db2_app_details
Type | Facet |
---|---|
xs:string | Max length: 32 |
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:int | optional |
TEntry flags1. Internal use only.
Contained by: db2_app_details
Type | Facet |
---|---|
xs:hexBinary | Max length: 8 |
TEntry flags2. Internal use only.
Contained by: db2_app_details
Type | Facet |
---|---|
xs:hexBinary | Max length: 8 |
XID - Global transaction identifier
Contained by: db2_app_details
Type | Facet |
---|---|
xs:hexBinary | Max length: 140 |
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
Type | Facet |
---|---|
xs:int |
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
Type | Facet |
---|---|
xs:string | Max length: 128 |
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
Type | Facet |
---|---|
xs:int |
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
Type | Facet |
---|---|
xs:string | Max length: 128 |
The operation currently being processed or most recently processed.
Contained by:db2_app_details
Type | Facet |
---|---|
xs:string | Max length: 32 |
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
Type | Facet |
---|---|
xs:string | Max length: 3 |
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
Type | Facet |
---|---|
xs:string | Max length: 3 |
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
Type | Facet |
---|---|
xs:string | Max length: 255 |
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
Type | Facet |
---|---|
xs:string | Max length: 255 |
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
Type | Facet |
---|---|
xs:string | Max length: 255 |
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
Type | Facet |
---|---|
xs:string | Max length: 255 |
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 | xs:string - Max length: 10 (lock, ticket ) | required |
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 (*)} )
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 | xs:string - Max length: 10 (current, past ) | required | |||
ANY attribute from ANY namespace |
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
Type | Facet |
---|---|
xs:hexBinary | Max length: 16 |
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
Type | Facet |
---|---|
xs:string | Max length: 32 |
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:long | optional |
Internal specifics about the lock. For information use only.
Contained by: db2_object_requested
Type | Facet |
---|---|
xs:string | Max length: 128 |
Lock attributes. See monitor element lock_attributes - Lock attributes monitor element for more details.
Contained by: db2_object_requested
Type | Facet |
---|---|
xs:hexBinary | Max length: 4 |
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
Type | Facet |
---|---|
xs:string | Max length: 32 |
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:long | optional | |||
mode | db2_string_type_6 | optional |
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
Type | Facet |
---|---|
xs:string | Max length: 32 |
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:long | optional | |||
mode | db2_string_type_6 | optional |
The type of lock being held. See monitor element lock_mode - Lock mode monitor element for more details.
Contained by:db2_object_requested
Type | Facet |
---|---|
xs:string | Max length: 32 |
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:long | optional | |||
mode | db2_string_type_6 | optional |
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:
Type | Facet |
---|---|
xs:long |
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:
Type | Facet |
---|---|
xs:long |
IID for Row locking. Internal use only.
Contained by: db2_object_requested
Element content:
Type | Facet |
---|---|
xs:long |
Indicates the internal status of the lock. See monitor element lock_status - Lock status monitor element for more details.
Contained by: db2_object_requested
Type | Facet |
---|---|
xs:string | Max length: 32 |
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:int | optional |
Lock release flags. See monitor element lock_release_flags - Lock release flags monitor element for more details.
Contained by: db2_object_requested
Type | Facet |
---|---|
xs:hexBinary | Max length: 4 |
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
Type | Facet |
---|---|
xs:string | Max length: 128 |
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:long | optional |
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
Type | Facet |
---|---|
xs:string | Max length: 128 |
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:long | optional | |||
data_member_id | member_type | optional | The identifier of the data member for which information is returned. |
The schema of the table. See monitor element table_schema - Table schema name monitor element for more details.
Contained by: db2_object_requested
Type | Facet |
---|---|
xs:string | Max length: 128 |
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
Type | Facet |
---|---|
xs:hexBinary | Max length: 1 |
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:
Type | Facet |
---|---|
xs:dateTime |
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 |
The name of the threshold queue.
Contained by: db2_object_requested
Type | Facet |
---|---|
xs:string | Max length: 128 |
The ID of the threshold queue.
Contained by: db2_object_requested
Type | Facet |
---|---|
xs:int |
The total number of agents currently queued in the threshold.
Contained by: db2_object_requested
Element content:
Type | Facet |
---|---|
xs:long |
The data and time the application started waiting in the queue to obtain a threshold ticket.
Contained by: db2_object_requested
Element content:
Type | Facet |
---|---|
xs:dateTime |
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 | member_type | required | |||
participant_no_holding_lk | xs:int | required | |||
application_handle | application_handle_type | required | |||
ANY attribute from ANY namespace |
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
Type | Facet |
---|---|
xs:int |
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
Type | Facet |
---|---|
xs:int |
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
Type | Facet |
---|---|
xs:string | Max length: 128 |
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
Type | Facet |
---|---|
xs:string | Max length: 128 |
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
Type | Facet |
---|---|
xs:string | Max length: 64 |
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
Type | Facet |
---|---|
xs:string | Max length: 8 |
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:
Type | Facet |
---|---|
xs:long |
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
Type | Facet |
---|---|
xs:string | Max length: 10 |
The package was incrementally bound at execution time. Possible values: Yes or No.
Contained by: db2_activity_details
Type | Facet |
---|---|
xs:string | Max length: 3 |
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
Type | Facet |
---|---|
xs:string | Max length: 2 |
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:long | optional |
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:
Type | Facet |
---|---|
xs:long |
The SQL statement Unicode flag. Possible values: Yes or No.
Contained by:db2_activity_details
Type | Facet |
---|---|
xs:string | Max length: 3 |
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:
Type | Facet |
---|---|
xs:int |
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
Type | Facet |
---|---|
xs:string | Max length: 10 |
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:long | required |
See monitor element stmt_operation/operation - Statement operation monitor element for more details.
Contained by: db2_activity_details
Type | Facet |
---|---|
xs:string | Max length: 128 |
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:
Type | Facet |
---|---|
xs:long |
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:
Type | Facet |
---|---|
xs:long |
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:
Type | Facet |
---|---|
xs:long |
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:
Type | Facet |
---|---|
xs:long |
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:
Type | Facet |
---|---|
xs:long |
The text of the SQL statement. See monitor element stmt_text - SQL statement text monitor element for more details.
Contained by: db2_activity_details
Type | Facet |
---|---|
xs:string | Max length: 2097152 |
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:
Type | Facet |
---|---|
xs:dateTime |
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:
Type | Facet |
---|---|
xs:dateTime |
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 (*)} )
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 (*)} )
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
Type | Facet |
---|---|
xs:int |
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
Type | Facet |
---|---|
xs:string | Max length: 3 |
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:int | required |
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
Type | Facet |
---|---|
xs:string | Max length: 3 |
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:int | required |
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
Type | Facet |
---|---|
xs:string | Max length: 16 |
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
Type | Facet |
---|---|
xs:string | Max length: 32768 |