Enhanced Locking Management | Teradata DSA - Enhanced Locking Management - BAR - Data Stream Architecture

Teradata® DSA User Guide

Product
BAR
Data Stream Architecture
Release Number
17.10
Published
April 2022
Language
English (United States)
Last Update
2022-04-08
dita:mapPath
het1611950545663.ditamap
dita:ditavalPath
vwp1576617377804.ditaval
dita:id
B035-3150
lifecycle
previous
Product Category
Software
Teradata Tools and Utilities

Normally, DSA locks all objects at the beginning of the backup. The object is unlocked once it is backed up. This ensures data consistency between objects but keeps all objects locked until the backup is complete.

With enhanced locking management, DSA locks one object at a time and unlocks it once it is backed up. DSA does not manage data consistency. Use enhanced locking management on objects that are not empty.

Severe performance degradation and failed jobs can occur when using enhanced locking management on a large number of empty objects. For best job performance, use a separate backup without enhanced locking management to back up databases with many small objects.