Job Settings Tab - Data Stream Architecture

Teradata Data Stream Architecture (DSA) User Guide

Product
Data Stream Architecture
Release Number
16.10
Published
August 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
mbk1487616377418.ditamap
dita:ditavalPath
3150_DSA_UG_1610.ditaval.ditaval
dita:id
B035-3150
lifecycle
previous
Product Category
Software
Teradata Tools and Utilities

The Job Settings tab allows changes to the default job settings that are created 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.
Dictionary Only
Backs up only the dictionary and table header information for each object.
You cannot use incremental 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
  • If the job permissions have not been defined, the permissions show as not shared.
  • If job permissions have been defined, the cumulative number of users and roles with shared permissions are shown.

Click Edit to open the Change Permissions dialog box if job permissions need to be changed.

  • Backup
  • Restore
  • Analyze
Abort On Access Rights Violation

If the box is not checked, allows the Teradata backup or restore job to proceed even when a DUMP access rights violation is encountered on an object.

If the box is checked, the job aborts when the access rights violation is encountered.

This checkbox appears only when the following are true:
  • Source system is 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
  • Analyze
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
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.
Disable fallback is not available unless Run as copy is checked. The icon appears when the mouse pointer is hovered over the checkbox.
  • Default is unchecked. If unchecked, restored tables are recreated with fallback automatically enabled.
  • Checked is not available.
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
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. Backup
Skip statistics Skips collecting statistics during a backup or restore job job. Supported in Teradata Database 16.0 and later.
  • Backup
  • Restore
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 target system.
ON
Compress data at the block level if allowed on the target 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 Teradata Database 16.0 and later. Restore
Map to a different database on destination system Database name to map to. Restore
Destination System Hash Map Select the DEFAULT or other hash map to restore to. Restore
Limit the maximum streams per node for this job checkbox 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