This topic describes the information that appears in the summary table.
Column | Description | Type | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Blocked User | User name whose query is blocked by another user | String or Number | ||||||||||||||||||||||||||||
Blocking Host | Logical host ID of the transaction that imposed the lock | Number | ||||||||||||||||||||||||||||
Blocking Level | Lock level of the transaction that imposed the lock. The following values indicate the level.
|
String | ||||||||||||||||||||||||||||
Blocking Mode | Lock level mode of the transaction that imposed the lock. The following values indicate the mode for Teradata Database 14.10 and later.
|
String | ||||||||||||||||||||||||||||
Blocking Session | Session number of the transaction that imposed the lock. The following session numbers are used to indicate database internal sessions.
|
Number | ||||||||||||||||||||||||||||
Blocking User | Username that is blocking the query of another user | String | ||||||||||||||||||||||||||||
Block Time | Date and time the session became blocked, displayed as mm/dd/yy hh:mm:ss | Number | ||||||||||||||||||||||||||||
Database | Database name on which the lock was requested | String or Number | ||||||||||||||||||||||||||||
Deadlock | Indicates whether the lock contention results in a deadlock. The following values indicate the type of deadlock.
|
String | ||||||||||||||||||||||||||||
Delay | Total time the transaction waited for the block, displayed as HH:MM:SS | Number | ||||||||||||||||||||||||||||
Host | Logical host ID of the transaction that was waiting for the lock | Number | ||||||||||||||||||||||||||||
Level | Lock level of the transaction that was waiting for the lock. The following values indicate the level.
|
String | ||||||||||||||||||||||||||||
Mode | Lock level mode of the transaction that was waiting for the lock. The following values indicate the mode for Teradata Database 14.10 and later.
|
String | ||||||||||||||||||||||||||||
Multiple Blocker | Indicates whether more than one transaction encountered the same lock contention. The following values indicate the status.
|
String | ||||||||||||||||||||||||||||
Processor ID | AMP identifier where the lock was requested | Number | ||||||||||||||||||||||||||||
Session | Session number of the transaction that was locked. The following session numbers are used to indicate database internal sessions.
|
Number | ||||||||||||||||||||||||||||
Table | Table name on which the lock was requested | String or Number |