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.
|
|
Backup Method |
Determines the type of backup to perform.
|
|
No sync checkbox |
Determines where synchronization is done for the job. Only available for online backup jobs.
|
|
Logging Level |
Determines the types of messages that the database job logs.
|
|
Job Permissions |
Click Edit to open the Change Permissions dialog box if job permissions need to be changed. |
|
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:
|
|
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.
|
|
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
|
Restore |
Run as copy checkbox | When checked allows the restore to run as a copy job.
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. |
|
Override temperature |
Determines the temperature at which data is restored.
|
Restore |
Block Level Compression |
Defines data compression used.
|
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.
|
|