Locking and Row Partitions - Teradata Vantage - Database Engine 20

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Database Engine 20
Teradata Vantage
Release Number
20.00
Publication Date
June 2025
Content Type
Administration
Configuration
Support
Publication ID
B035-1102-200K
ft:locale
en-US
ft:lastEdition
2026-03-26
dita:mapPath
ron1747160181474.ditamap
dita:ditavalPath
ft:empty
ft:sourceId
dita
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantageā„¢

To allow the Lock Manager to request locks at row-partition granularities, Vantage employs a value called a rowkey, which combines a row partition identifier (the internal partition number or IPN) with a rowhash value. The rowkey allows the Lock Manager to consider row partitions in determining the type of lock to use for a given transaction. The Lock Manage can thereby limit locks, when appropriate, to rows in a single row-partition, allowing concurrent access to the non-locked partitions of the table.

Partition-aware locks are identified in the output of Lock Display by having a PLLKind descriptor.