Locked Object Restrictions - Data Stream Architecture

Teradata Data Stream Architecture (DSA) User Guide

Product
Data Stream Architecture
Release Number
16.10.01
Published
November 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
fyx1509665931452.ditamap
dita:ditavalPath
3150_DSA_UG_1610.ditaval.ditaval
dita:id
B035-3150
Product Category
Software
Teradata Tools and Utilities

The Teradata Database 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 "LOCKED" to indicate that the object is locked. If this situation, you might want to abort the job and run the object_release command to attempt to release the locks, so that the job can be run when all of the objects can be accessed.