Summary Locks - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
16.50
16.20
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
yqb1520516846011.ditamap
dita:ditavalPath
yqb1520516846011.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem
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.
Database Locked at the database level
Table Locked at the table level
Row hash Locked at the row level
Table partition range Locked at the table partition level
Row hash in partition range Locked at the row level in the partition range
Row hash in one partition Locked at the row level in one partition
Row key range Locked for a range of rows
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.
Access Access
IAccess Intentional Access
Exclusive Exclusive
IExclusive Intentional Exclusive
Read Read
IRead Intentional Read
ReadHL Read HUT (Host Utility) Lock
IReadHL Intentional Read HUT (Host Utility) Lock
Read4X Read for Exclusive
IRead4X Intentional Read for Exclusive
Read4W Read for Write
IRead4W Intentional Read for Write
Write Write
IWrite Intentional write
String
Blocking Session Session number of the transaction that imposed the lock. The following session numbers are used to indicate database internal sessions.
0 System User
1 System Accounting
2 System Recovery
3 Archive/Restore
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.
N No deadlock
Y Local deadlock
G Global 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.
Database Locked at the database level
Table Locked at the table level
Row hash Locked at the row level
Table partition range Locked at the table partition level
Row hash in partition range Locked at the row level in the partition range
Row hash in one partition Locked at the row level in one partition
Row key range Locked for a range of rows
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.
Access Access
IAccess Intentional Access
Exclusive Exclusive
IExclusive Intentional Exclusive
Read Read
IRead Intentional Read
ReadHL Read HUT (Host Utility) Lock
IReadHL Intentional Read HUT (Host Utility) Lock
Read4X Read for Exclusive
IRead4X Intentional Read for Exclusive
Read4W Read for Write
IRead4W Intentional Read for Write
Write Write
IWrite Intentional write
String
Multiple Blocker Indicates whether more than one transaction encountered the same lock contention. The following values indicate the status.
Y Two or more blocked transactions
N One blocked transaction
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.
0 System User
1 System Accounting
2 System Recovery
Number
Table Table name on which the lock was requested String or Number