Job Settings Tab | Teradata DSA - Job Settings Tab - BAR - Data Stream Architecture

Teradata® DSA User Guide

Data Stream Architecture
Release Number
November 2022
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

The Job Settings tab is available when creating or cloning a job and allows you to select and define job settings for backup, restore, and analyze jobs.

Field Description Job Type
Automatically Retire Determines whether a job is retired automatically.
Default. The job is not retired automatically. The job retire must be set manually.
Specifies the time, in days or weeks, that a job is automatically retired.
  • Backup
  • Restore
  • Analyze
Backup Method Determines the type of backup to perform.
Default. Backs up everything associated with each specified object while the database is offline. No updates can be made to the objects during the backup job run.
Backs up everything associated with each specified object and initiates an online archive for all objects being archived. The online archive creates a log that contains all changes to the objects while the archive is prepared.
A DBC only backup job cannot be run as online.
Dictionary Only
Backs up only the dictionary and table header information for each object.
You cannot use cumulative or delta backup on a Dictionary Only backup job.
  • Backup
No sync checkbox Determines where synchronization is done for the job. Only available for online backup jobs.
Default. Synchronization occurs across all tables simultaneously. If you try to run a job that includes objects that are already being logged, the job aborts.
There can be different synchronization points. If you try to run a job that includes objects that are already being logged, the job runs to completion and a warning is returned.
  • Backup
Logging Level
Determines the types of messages that the database job logs.
Default. Enables minimal logging. Provides only error messages.
Adds warning messages to error message logging.
Provides informational messages with warning and error messages to the job log.
Enables full logging. All messages, including Debug, are sent to the job log.
  • Backup
  • Restore
  • Analyze_Validate
Job Permissions
  • Not shared Job permissions have not been defined.
  • Shows the cumulative number of users and roles with shared permissions, if job permissions have been defined.
  • Job permissions include Run, Edit, or both.

Click Edit to define or change permissions.

  • Backup
  • Restore
  • Analyze
Abort On Access Rights Violation
Allows the Teradata backup or restore job to proceed even when a DUMP access rights violation is encountered on an object.
Default. Job aborts when the access rights violation is encountered.
This checkbox appears only when the following are true:
  • Source system is Analytics Database 16.20 or later / Teradata Database version or later
  • Source system and target group credentials have been validated
  • When creating or editing a Teradata backup or restore job
  • Backup
  • Restore
Query Band
Allows tagging of sessions or transactions with a set of user-defined name-value pairs to identify where a query originated. These identifiers are in addition to the current set of session identification fields, such as user ID, account string, client ID, and application name.
Valid query band values are defined on the database.

DSA creates query bands for restore jobs when an override temperature or block level compression option has a value other than DEFAULT. You can enter different query bands in the bottom text box.

  • Backup
  • Restore
Run as copy checkbox When checked allows the restore to run as a copy job.
  • A copy job assumes the destination database is not the original database system on the backup job and the database ID is different.
  • A copy job is used when restoring to a database with a different internal database ID than the one in the backup save set.
Do not use Run as copy when the database system is the original database and the database ID matches the one found in the backup save set.
Disable Fallback checkbox Fallback protection means that a copy of every table row is maintained on a different AMP in the configuration. Fallback-protected tables are always fully accessible and are automatically recovered by the system.
  • [Teradata Database 16.20 Update 1 and later] Fallback cannot be disabled. Checkbox is ignored.
  • [Prior versions of Teradata Database] Disable fallback is not available unless Run as copy is checked. The icon
    appears when the mouse pointer is hovered over the checkbox.
Default. Restored tables are recreated with fallback automatically enabled.
Fallback is not available.
DBC Credentials DBC only backup. Click Set Credentials to open the Enter Credentials dialog box if DBC credentials need to be established. Restore
Advanced Settings button
Track empty tables Tracks empty tables during a backup job.

Supported in Teradata Database 16.0 and later.

Skip statistics Skips collecting statistics during a backup or restore job.

Supported in Analytics Database 16.20 and later / Teradata Database 16.0 and later.

  • Backup
  • Restore
Enhanced Locking Management checkbox Checked. DSA locks one object at a time. The object is unlocked once it is backed up. DSA does not manage data consistency.

Unchecked. 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.

Backup (offline only)
Override Temperature
Determines the temperature at which data is restored.
Default. This data is restored at the default temperature setting for the system.
This data is accessed frequently.
This data is accessed less frequently.
This data is accessed least frequently.
Block Level Compression
Defines data compression used.
Default. Applies same data compression as the backup job if allowed on the destination system.
Compress data at the block level if allowed on the destination system.
Restore the data blocks uncompressed.
Concurrent Builds Per Table Number of index and fallback subtables that can be built concurrently per table during restore.

Supported in Analytics Database 16.20 and later / Teradata Database 16.0 and later.

Map to a different database on destination system Database name to map to. Restore
Limit the maximum streams per node for this job When checked, overrides the system level stream soft limit. Range is 1 to 1 - max of the stream soft limit, where max is the number of AMPs per node in the system.
Job level entry overrides the system level setting.
  • Backup
  • Restore
  • Analyze_Validate
Skip join/hash index When checked, skips archiving the join and hash index during a backup job or skips restoring the join index during a restore job.
  • Backup
  • Restore
Skip build secondary indexes

[Analytics Database 16.20 Update 2]

When checked, skips building secondary indexes during incremental restore. Incremental Restore