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

Teradata® DSA User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
BAR
Data Stream Architecture
Release Number
17.20
Published
November 2022
Language
English (United States)
Last Update
2023-11-30
dita:mapPath
bis1632417576364.ditamap
dita:ditavalPath
vwp1576617377804.ditaval
dita:id
cyv1467242268519
Product Category
Software
Teradata Tools and Utilities

When processing a backup job begins, DSA gets a Host Utility (HUT) Read lock on every object in the job plan. If the job plan includes a database, DSA puts a Read HUT on the whole database. If it includes an object, DSA puts a Read HUT lock on the object. DSA requires all the HUT Read locks for every object in the job plan to be acquired before the objects are actually archived, so there is a consistent sync point and data integrity can be guaranteed when the data is restored.

Additionally, the backup job locks access on several DBC tables to get the object definitions. The locks are held for the duration of the DUMP command and are released as soon as possible. Once the DUMP command is complete, the locks are released so they are not held while the dictionary data is being written or during the rest of the dictionary phase.

Some of the tables that DSA locks are: TVM, DBASE, UDFINFO, TEXTTBL, IDCOL, DEPENDENCY, JAR_JAR_USAGE, ROUTINE_JAR_USAGE, ERRORTBLS, JARS, REFERENCEDTBLS, REFERENCINGTBLS, CONSTRAINTNAMES, TRIGGERSTBL, UIF_INFO, SERVERTBLOPINFO, DBCASSOCIATION, INDEXES, TVFIELDS, SERVERINFO, and TABLECONSTRAINTS. There is also a Read lock placed on the ARCHIVELOGGINGOBJSTBL. These are table level access locks.

The HUT Read lock is released as soon as the object is completely archived. For objects without a table header that are archived at the object level, the lock is released at the end of the dictionary phase. For tables that are archived at the object level, the lock is released as soon as the object is completely archived. For database level locks, the lock is released as soon as all the objects in the database have been completely archived.

The last database or object processed for the archive job requires the lock for the entire job.