RollForwardLock - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

Purpose

Defines the system default for the RollForward using Row Hash Locks option. This allows the database administrator to specify that row hash locks should be used to lock the target table rows during a RollForward. Row hash locks reduce lock conflicts, so that users are more likely to be able to access data during the RollForward operation.

Field Group

General

Valid Settings

Setting Description
TRUE Enables this feature.
FALSE Disables this feature.

Default

FALSE

Changes Take Effect

After the next Teradata Database restart.