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 Options | Description | Job Type |
---|---|---|
online |
Determines the type of backup to perform.
|
|
dataphase |
Determines the type of backup to perform.
|
|
enable_temperature_override | Optional setting that pertains to restore jobs only.
|
|
nosync |
Determines where synchronization is done for the job. Only available for online backup jobs.
|
|
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.
|
|
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.
|
|
temperature_override |
Determines the temperature at which data is restored.
|
|
block_level_compression |
Defines data compression used.
|
|
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.
|
|
run_as_copy |
Allows restore to run as a copy.
|
|