DSA Backup Locking Strategy for Online Jobs | Teradata DSA - DSA Backup Locking Strategy for Online Jobs - BAR - Data Stream Architecture

Teradata® DSA User Guide

Product
BAR
Data Stream Architecture
Release Number
17.05
Published
September 2020
Language
English (United States)
Last Update
2021-04-02
dita:mapPath
ihc1599061140065.ditamap
dita:ditavalPath
vwp1576617377804.ditaval
dita:id
B035-3150
lifecycle
previous
Product Category
Software
Teradata Tools and Utilities
For online backups, the user can select the NoSync option. When NoSync is true, the locking process does the following:
  1. Submits the Archive Logging On statement for all the objects in the job plan, which will try to lock all the objects to get a consistency point.
  2. If DSMain cannot get the lock, it will do the following:
    1. Return the list of objects that had lock conflicts to DSC, and job_status_log can be used to display the objects with lock conflicts.
    2. Release the locks on those objects with lock conflicts, to ensure the locks are released in the event of a deadlock.
    3. Resubmit the lock statement for the objects with lock conflicts and wait indefinitely for the locks.