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

SQL Request and Transaction Processing

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
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.