Script Options - BAR

Teradata Appliance Backup Utility Installation and User Guide

Product
BAR
Release Number
16.20
Published
November 2017
Language
English (United States)
Last Update
2018-07-13
dita:mapPath
myx1512701901323.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-3134
Product Category
Teradata Tools and Utilities
The Script Options dialog box provides options for scripts that run backup and restore jobs.

When using the Script Options dialog box for backup jobs, you can override the parameters that were set through the configuration script. Specify the number of streams and sessions per stream that match your system setup. If you change the number of streams from the default, also change the number of sessions per stream, assign clients, and assign destination paths.

Option Description
Job Name Allows you to enter the case-sensitive job name, which cannot contain any spaces or these characters: < > ~ " * , ? . \ /
TDPID

Backs up or restores the TDPID with which you logged on. You cannot change the TDPID.

UserName Displays the user name with which you logged on. To create another job for the specified database, enter a new user name.
Password Displays the password with which you logged on. To create another job for the specified database using another user name and password, enter a new password.
Sessions (per stream) Allows you to define the number of sessions to assign per stream. The optimal number of sessions to assign to each stream is one session for every AMP in the node.
If the node has 25 AMPs and 1 stream, assign 25 sessions to the stream. If the node has more than 1 stream, then divide the number of AMPs by the number of streams and round up. For example: 25 AMPs with 2 streams = 13 sessions.

An adequate number of parallel ARC sessions per stream is necessary to keep data moving. Too few sessions cause ARCMAIN to be the bottleneck during the backup or restore process. Too many sessions waste resources because some of the sessions remain idle.

ARC Command-Line Options Allows you to define any ARCMAIN command-line options that do not override the Appliance Backup Utility multi-stream capabilities. An example of a valid entry is VB3, which is a debug parameter that ARCMAIN uses to enable a level of tracing.
Data and Dictionary Backs up and restores one of the following:
  • Dictionary Only
  • Data and Dictionary
When specifying Dictionary Only for a backup job, specify only one stream per job. The default is Data and Dictionary.
The restore job setting must match the associated backup job setting or the restore job will fail. For example, if the backup job has the Dictionary Only setting, the associated restore job must have the Dictionary Only setting.
Online Backup (Backup only) Backs up rows from a table synchronously with update, insert, or delete operations and creates a log that contains all changes to the table. When the table is restored or copied, the recorded changes are used to roll back those changes in the table. The table is rolled back to the point that was established when online archive logging started on that table.

Online backup also creates table locks during the synchronization process, therefore do not use the Online Backup option when there is a heavy database workload.

With the NoSync option, no read or access lock is placed on the database and the tables are not synchronized. The tables do not have a shared consistency point. Instead, each table has its own consistency point for restore jobs. The primary purpose of NoSync is to minimize the effect of transactions writing to the database. Refer to Teradata Archive/Recovery Utility Reference, B035-2412 for more information.

Number of Streams Allows you to define the number of streams per node. The default is the number of nodes specified during configuration.
Clients Assigns a specific Appliance Backup Utility client (or a specific client group) to each stream. The default assigns a stream to each Appliance Backup Utility client, which distributes the workload across all Teradata Database nodes and improves backup and restore performance.
Destination Path (Backup only) Specifies a destination path for each backup stream. All destination paths are displayed and are not filtered for a specific client.
Do not specify a system disk as a destination path.
Save Accepts the current script.
Launch Launches the job.
Preview Opens the Script Editor dialog box and displays the job script, which you can edit and save.
Close Closes the Script Options dialog box.