Locked Object Restrictions | Teradata DSA - Locked Object Restrictions - BAR - Data Stream Architecture

Teradata® DSA User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
BAR
Data Stream Architecture
Release Number
17.20
Published
November 2022
Language
English (United States)
Last Update
2023-11-30
dita:mapPath
bis1632417576364.ditamap
dita:ditavalPath
vwp1576617377804.ditaval
dita:id
cyv1467242268519
Product Category
Software
Teradata Tools and Utilities

The Teradata system places locks on objects during the time that transactions take place. For example, if a transaction is taking place on a table, you cannot run a read operation until the previous transaction is complete.

If there are locks on objects included in a job, DSA waits indefinitely until the locks are released. When this happens, the object status in the Log tab of the Job Status view displays "BLOCKED" to indicate that the object is locked. Release the locks so that the job can be run when all of the objects can be accessed.