16.20 - DSA Enhanced Locking Management for Backups - Teradata Vantage NewSQL Engine

Teradata Vantage™ NewSQL Engine Release Summary

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Release Notes
featnum
B035-1098-162K

Prior to this release, a backup operation locked all objects for backup at the start of the operation. Optionally in this release, you can have the database lock only those objects that are actively in the process of being backed up, leaving the other objects available until they are being backed up.

Benefits

  • Maintains availability of objects that are not actively being backed up.
  • Reduces locking duration for individual objects being backed up.
  • No impact to restore speeds.

Considerations

  • Backup will be slower for jobs consisting of many small objects or jobs that include skewed objects.
  • When Enhanced Locking Management is in effect, Teradata cannot guarantee transaction consistency across multiple objects in the same backup job.
  • Objects that are dropped during the backup operation but prior to themselves being backed up are listed as having a status of SKIPPED.
  • Backup job progress may show streams working on different tables concurrently. This is an artifact of the implementation. Only one object is backed up at a time.

Additional Information

For more information about Enhanced Lock Management, see Teradata® DSA User Guide, B035-3150.