You can select and define job options for backup, restore, and analyze jobs by specifying the values for the options in the XML file containing the job definition.
The XML files in the sample library and the files produced by the BAR Operations portlet have the XML in a specific order. For the jobs to run correctly, do not change the order of the XML within the files.
The following options are for Teradata only.
Job Option | Description | Job Type |
---|---|---|
online |
Determines the type of backup to perform.
|
Backup |
nosync |
Determines where synchronization is done for the job. Only available for online backup jobs.
|
Backup |
data_phase |
Determines the type of backup to perform.
|
Backup |
enable_temperature_override | Optional setting that pertains to restore jobs only.
|
Restore |
temperature_override |
Determines the temperature at which data is restored.
|
Restore |
block_level_compression |
Defines data compression used.
|
Restore |
disable_fallback |
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.
Default is false. Must be entered in lowercase letters.
The disable_fallback option only takes effect when the run_as_copy value is true.
|
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.
|
|
dsmain_logging_level |
Determines the types of messages that the database job logs.
|
|
nowait | Generates warning messages to the job status log for objects that the Teradata Database fails to get locks on immediately. In either case, the job waits until the lock is released.
|
|
reblock | Determines level of inserts, either row or block level. This option is valid only for the same configuration restore. Different configuration restore always use row level inserts.
|
Restore |
run_as_copy |
Allows restore to run as a copy.
|
Restore |
skip_archive | Optional, can be true or false. Skip archive during backup or restore job in case of error in access rights. Supported in Teradata Database 15.10.01 and later. |
|
skip_stats | Optional, can be true or false. Skips collecting statistics during a backup job. Skips restoring stats during a restore job. Supported in Teradata Database 16.0 and later. |
|
track_empty_tables | Optional, can be true or false. Tracks empty tables during a backup job. Supported in Teradata Database 16.0 and later. | Backup |
concurrent_bld_per_tbl | Optional, range is 1 to 5. 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 | Optional. Apply map_to to all objects in the restore job. Supported in Teradata Database 16.0 and later. | Restore |