PARTITION_KEY |
INTEGER |
partition_key - Partitioning key monitor element |
AGENT_STATUS |
INTEGER |
agent_status - DCS
application agents |
AGENT_TID |
BIGINT |
agent_tid - Agent thread ID monitor element |
APPL_ACTION |
VARCHAR(64) |
appl_action - Application action monitor element |
APPL_ID |
VARCHAR(128) |
appl_id - Application
ID |
APPL_NAME |
VARCHAR(128) |
appl_name - Application
name |
APPLICATION_HANDLE |
BIGINT |
application_handle
- Application handle |
AUTH_ID |
VARCHAR(128) |
auth_id - Authorization
ID |
CLIENT_ACCTNG |
VARCHAR(255) |
client_acctng - Client
accounting string |
CLIENT_APPLNAME |
VARCHAR(255) |
client_applname -
Client application name |
CLIENT_USERID |
VARCHAR(255) |
client_userid - Client
user ID |
CLIENT_WRKSTNNAME |
VARCHAR(255) |
client_wrkstnname
- Client workstation name |
COORD_AGENT_TID |
BIGINT |
coord_agent_tid - Coordinator agent engine dispatchable unit ID monitor element |
CURRENT_REQUEST |
VARCHAR(32) |
current_request - Current operation request monitor element |
DEADLOCK_MEMBER |
SMALLINT |
deadlock_member - Deadlock member monitor element |
EVENT_ID |
BIGINT |
event_id - Event ID monitor element |
EVENT_TIMESTAMP |
TIMESTAMP |
event_timestamp - Event timestamp monitor
element |
EVENT_TYPE |
VARCHAR(128) |
event_type - Event Type monitor element
monitor element |
INTERNAL_DATA |
VARCHAR(255) |
This column is reserved for internal processing
data. |
LOCK_ATTRIBUTES |
CHAR(8) |
lock_attributes -
Lock attributes |
LOCK_COUNT |
BIGINT |
lock_count - Lock
count |
LOCK_CURRENT_MODE |
BIGINT |
lock_current_mode
- Original lock mode before conversion |
LOCK_ESCALATION |
CHAR(3) |
lock_escalation -
Lock escalation |
LOCK_HOLD_COUNT |
BIGINT |
lock_hold_count -
Lock hold count |
LOCK_MODE |
BIGINT |
lock_mode - Lock
mode |
LOCK_MODE_REQUESTED |
BIGINT |
lock_mode_requested
- Lock mode requested |
LOCK_NAME |
CHAR(32) |
lock_name - Lock
name |
LOCK_OBJECT_TYPE |
BIGINT |
lock_object_type
- Lock object type waited on |
LOCK_OBJECT_TYPE_ID |
CHAR(1) |
Reserved for future use |
LOCK_RELEASE_FLAGS |
CHAR(8) |
lock_release_flags
- Lock release flags |
LOCK_RRIID |
BIGINT |
|
LOCK_STATUS |
BIGINT |
lock_status - Lock
status |
LOCK_TIMEOUT_VAL |
BIGINT |
lock_timeout_val
- Lock timeout value |
LOCK_WAIT_END_TIME |
TIMESTAMP |
lock_wait_end_time - Lock wait end timestamp monitor element |
LOCK_WAIT_START_TIME |
TIMESTAMP |
lock_wait_start_time
- Lock wait start timestamp |
LOCK_WAIT_VAL |
BIGINT |
lock_wait_val - Lock wait value monitor element |
MEMBER |
SMALLINT |
member - Database
member |
OBJECT_REQUESTED |
VARCHAR(10) |
object_requested - Requested object monitor element |
PARTICIPANT_NO |
INTEGER |
participant_no -
Participant within deadlock |
PARTICIPANT_NO_HOLDING_LK |
INTEGER |
participant_no_holding_lk
- Participant holding a lock on the object required by application |
PARTICIPANT_TYPE |
VARCHAR(10) |
participant_type - Participant type monitor element |
PAST_ACTIVITIES_WRAPPED |
CHAR(3) |
past_activities_wrapped - Past activities list wrapped monitor element |
QUEUE_START_TIME |
TIMESTAMP |
queue_start_time - Queue start timestamp monitor element |
QUEUED_AGENTS |
BIGINT |
queued_agents - Queued threshold agents monitor element |
SERVICE_CLASS_ID |
INTEGER |
service_class_id
- Service class ID |
SERVICE_SUBCLASS_NAME |
VARCHAR(128) |
service_subclass_name
- Service subclass name |
SERVICE_SUPERCLASS_NAME |
VARCHAR(128) |
service_superclass_name
- Service superclass name |
TABLE_FILE_ID |
BIGINT |
table_file_id - Table
file identification |
TABLE_NAME |
VARCHAR(128) |
table_name - Table
name |
TABLE_SCHEMA |
VARCHAR(128) |
table_schema - Table
schema name |
TABLESPACE_NAME |
VARCHAR(128) |
tablespace_name -
Table space name |
THRESHOLD_ID |
INTEGER |
thresholdid - Threshold ID monitor element |
THRESHOLD_NAME |
VARCHAR(128) |
threshold_name -
Threshold name |
UTILITY_INVOCATION_ID |
VARCHAR(32) FOR BIT DATA |
|
WORKLOAD_ID |
INTEGER |
workload_id - Workload
ID |
WORKLOAD_NAME |
VARCHAR(128) |
workload_name - Workload
name |
XID |
VARCHAR(140) |
xid - Transaction
ID |