Release Database Transaction locks | Vantage - Releasing Database Lock - Analytics Database - Teradata Vantage

SQL Request and Transaction Processing

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
zfm1628111633230.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
evd1472255317510
lifecycle
latest
Product Category
Teradata Vantageā„¢

Database HUT Locks (Archive or Recovery) are released as soon as the DSA job is completed or aborted. If there are any left over Database HUT locks after the job run, then use the object_release command to release them.

If a failure, time out, abort, rollback, logoff, or system restart occurs, rollback of the work already performed by the transaction may delay releasing locks and the availability of the locked objects.

In ANSI session mode, the Lock Manager does not release locks placed for a rolled back request.