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.
The following values indicate the mode for Teradata Database 14.01 and earlier:
|
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.
The following values indicate the mode for Teradata Database 14.01 and earlier.
|
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 |