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

Teradata® DSA User Guide

Product
BAR
Data Stream Architecture
Release Number
17.20
Release Date
October 2021
Content Type
User Guide
Publication ID
B035-3150-101K
Language
English (United States)

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.
Never
Default. The job is not retired automatically. The job retire must be set manually.
After
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.
Offline
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.
Online
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.
Unchecked
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.
Checked
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.
error
Default. Enables minimal logging. Provides only error messages.
warning
Adds warning messages to error message logging.
info
Provides informational messages with warning and error messages to the job log.
debug
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
Unchecked
Allows the Teradata backup or restore job to proceed even when a DUMP access rights violation is encountered on an object.
Checked
Default. Job aborts when the access rights violation is encountered.
This checkbox appears only when the following are true:
  • Source system is Advanced SQL Engine 16.20 or later / Teradata Database version 15.10.01.00 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.
Restore
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.
  • [Advanced SQL Engine 16.20 Update 1 and later] Fallback cannot be disabled. Checkbox is ignored.
  • [Prior versions of Advanced SQL Engine / 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.
Unchecked
Default. Restored tables are recreated with fallback automatically enabled.
Checked
Fallback is not available.
Restore
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 Advanced SQL Engine / Teradata Database 16.0 and later.

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

Supported in Advanced SQL Engine 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
Default. This data is restored at the default temperature setting for the system.
HOT
This data is accessed frequently.
WARM
This data is accessed less frequently.
COLD
This data is accessed least frequently.
Restore
Block Level Compression
Defines data compression used.
DEFAULT
Default. Applies same data compression as the backup job if allowed on the destination system.
ON
Compress data at the block level if allowed on the destination system.
OFF
Restore the data blocks uncompressed.
Restore
Concurrent Builds Per Table Number of index and fallback subtables that can be built concurrently per table during restore.

Supported in Advanced SQL Engine 16.20 and later / Teradata Database 16.0 and later.

Restore
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

[Advanced SQL Engine 16.20 Update 2]

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