XMLID |
VARCHAR(1000) NOT NULL |
|
PARTICIPANT_NO |
INTEGER |
participant_no - Participant within Deadlock monitor element |
PARTICIPANT_TYPE |
VARCHAR(10) |
|
PARTICIPANT_NO_HOLDING_LK |
INTEGER |
participant_no_holding_lk - Participant Holding a Lock on the Object Required by Application monitor element |
APPLICATION_HANDLE |
BIGINT |
application_handle - Application handle monitor element |
APPL_ID |
VARCHAR(128) |
appl_id - Application ID monitor element |
APPL_NAME |
VARCHAR(128) |
appl_name - Application name monitor element |
AUTH_ID |
VARCHAR(128) |
auth_id - Authorization ID monitor element |
AGENT_TID |
BIGINT |
|
COORD_AGENT_TID |
BIGINT |
|
AGENT_STATUS |
INTEGER |
appl_status - Application Status monitor element |
LOCK_TIMEOUT_VAL |
BIGINT |
lock_timeout_val - Lock timeout value monitor element |
LOCK_WAIT_VAL |
BIGINT |
The amount of time spent in lock wait (in milliseconds)
before an event for mon_lockwait is generated. |
WORKLOAD_ID |
INTEGER |
workload_id - Workload ID monitor element |
WORKLOAD_NAME |
VARCHAR(128) |
workload_name - Workload name monitor element |
SERVICE_CLASS_ID |
INTEGER |
service_class_id - Service class ID monitor element |
SERVICE_SUBCLASS_NAME |
VARCHAR(128) |
service_subclass_name - Service subclass name monitor element |
CURRENT_REQUEST |
VARCHAR(32) |
|
LOCK_ESCALATION |
CHAR(3) |
lock_escalation - Lock escalation monitor element |
PAST_ACTIVITIES_WRAPPED |
CHAR(3) |
|
CLIENT_USERID |
VARCHAR(255) |
client_userid - Client user ID monitor element |
CLIENT_WRKSTNNAME |
VARCHAR(255) |
client_wrkstnname - Client workstation name monitor element |
CLIENT_APPLNAME |
VARCHAR(255) |
client_applname - Client application name monitor element |
CLIENT_ACCTNG |
VARCHAR(255) |
client_acctng - Client accounting string monitor element |
OBJECT_REQUESTED |
VARCHAR(10) |
|
LOCK_NAME |
CHAR(32) |
lock_name - Lock name monitor element |
LOCK_OBJECT_TYPE |
VARCHAR(32) |
lock_object_type - Lock object type waited on monitor element |
LOCK_OBJECT_TYPE_ID |
CHAR(1) FOR BIT DATA |
|
LOCK_ATTRIBUTES |
CHAR(8) |
lock_attributes - Lock attributes monitor element |
LOCK_CURRENT_MODE |
BIGINT |
lock_current_mode - Original lock mode before conversion monitor element |
LOCK_MODE_REQUESTED |
BIGINT |
lock_mode_requested - Lock mode requested monitor element |
LOCK_MODE |
BIGINT |
lock_mode - Lock mode monitor element |
LOCK_COUNT |
BIGINT |
lock_count - Lock count monitor element |
LOCK_HOLD_COUNT |
BIGINT |
lock_hold_count - Lock hold count monitor element |
LOCK_RRIID |
BIGINT |
|
LOCK_STATUS |
BIGINT |
lock_status - Lock status monitor element |
LOCK_RELEASE_FLAGS |
CHAR(8) |
lock_release_flags - Lock release flags monitor element |
LOCK_WAIT_START_TIME |
TIMESTAMP |
lock_wait_start_time - Lock wait start timestamp monitor element |
LOCK_WAIT_END_TIME |
TIMESTAMP |
|
TABLE_FILE_ID |
BIGINT |
table_file_id - Table file ID monitor element |
TABLE_NAME |
VARCHAR(128) |
table_name - Table name monitor element |
TABLE_SCHEMA |
VARCHAR(128) |
table_schema - Table schema name monitor element |
TABLESPACE_NAME |
VARCHAR(128) |
tablespace_name - Table space name monitor element |
THRESHOLD_ID |
INTEGER |
|
THRESHOLD_NAME |
VARCHAR(128) |
threshold_name - Threshold name monitor element |