Lock Modes | Teradata Unity - 17.00 - Lock Modes - Continuous Availability - Teradata Unity

Teradata® Unity™ User Guide

Product
Continuous Availability
Teradata Unity
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2020-09-15
dita:mapPath
fmz1594836948704.ditamap
dita:ditavalPath
qqk1595871525984.ditaval
The following table lists the types of lock modes. It also defines which modes can block or be blocked by another lock mode. These locks are internal to Unity and are not Teradata Database locks.
Lock Mode Blocks/Blocked By Modes
Exclusive Access, Write, Read
Access Exclusive
Write Read, Exclusive, other Writes
Read Write, Exclusive

Unity holds locks for the duration of a transaction. Session mode and TCL statements determine transaction duration. Only one transaction can hold a Write or Exclusive lock on an object at one time, but multiple transactions can be granted Read locks and Access locks simultaneously.

For Read queries, the session isolation level determines whether an Access or Read lock is used. It also determines if any locking modifiers exist in the query and relevant database configuration parameter values. For Write queries, any Read of any object always results in a Read lock. This ensures consistent results across all Teradata systems.