16.20 - DSA: Skip Archive Object Instead of Aborting When DUMP/RESTORE Privilege Is Not Present - 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

If a user running a Data Stream Architecture (DSA) backup/restore job does not have DUMP/RESTORE privileges for all database objects in the job, DSA aborts the job. This may cause problems because backup/restore jobs often run at night. A DBA may not have time to discover the issue and rerun the job during the nightly backup window. A new DSA job option skip_archive allows customers running a backup/restore job to skip over objects for which the user does not have privileges to back up or restore. DSA issues a warning and continues the job when it encounters a DUMP/RESTORE privilege violation.

Benefits

  • Prevents loss of a backup cycle
  • Protects customer data

Considerations

Users must explicitly include the skip_archive option in the XML file containing the job definition. Without this option, a DUMP/RESTORE privilege violation causes the job to abort.

Additional Information

For more information, see Teradata® DSA User Guide, B035-3150.