Script Options Dialog Box for Archive Operations - NetBackup

Teradata Extension for NetBackup Administrator Guide

Product
NetBackup
Release Number
16.20
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-02
dita:mapPath
bby1489436039204.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2400
Product Category
Teradata Tools and Utilities


  • To access this dialog box, click File > Build ARC > script from the ARCHIVE object selection dialog box. Use this dialog box to specify parameters when building an ARC script. Dialog box options are described in the following table.
    Script Options Dialog Box for Archive Operations
    Option Description
    Job Name Entries in Job Name are case-sensitive. A job name must not contain any spaces, or these characters:

    <

    >

    ~

    "

    *

    ,

    ?

    \

    /

    Description
    TDPID The entry in this box reflects the TDPID with which you logged on. It is not possible to change the TDPID.
    User Name The user name with which you logged on appears. To create another job for the specified database, type a new user name.
    Password The password with which you logged on appears. To create another job for the specified database using another user name and password, type the new password.
    Single stream or

    Multi stream

    Click Single stream or Multi stream. For Multi stream, type the number of streams in the Multi stream box. The number of streams is essentially the number of BAR server tape drives that are configured. For example, if there are four BAR servers, each having two tape drives, enter eight streams.
    Default Group The list defaults to all clients, which are assigned to streams in a round-robin manner. For example, if there are six streams and four clients, the stream assignment is:
    • Client1 is assigned to Stream1
    • Client2 is assigned to Stream2
    • Client3 is assigned to Stream3
    • Client4 is assigned to Stream4
    • Client1 is assigned to Stream5
    • Client2 is assigned to Stream6

    If there are many clients, select a name from the list of available client groups. Using a client group reduces the amount of selections needed when building a new archive or restore job.

    Assign Clients Each stream is defaulted to All clients. Click Assign Clients to assign a specific client (or a specific client group) to each stream.
    Configure
    Protegrity Encryption This option is no longer valid. The Crypto Key Management System (KMS) replaces Protegrity encryption.
    QueryBanding [Optional] Select QueryBanding. In the QueryBanding box, specify one or more pairs of names with associated values to identify the source of a query. This allows setting different priorities for different requests, and the ability to make better use of system resources.

    For example, enter a name and value pair, ending with a semi-colon:

    aaa=bbb;ccc=ddd;

    See Teradata Archive/Recovery Utility Reference (B035-2412) for more information on query banding.

    Online Backup [Optional]

    Select Online Backup to archive rows from a table at the same time update, insert, or delete operations on the table are taking place.

    When an online archive is initiated on a table or a database, a log is created for the specified table or separate logs are created for each table in the specified database. The log, which contains all changes to the table, is saved as a part of the archive process. When the table is restored or copied, the changes recorded in the log 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 was started on that table.

    In the drop-down list that is enabled, select Default or NoSync.

    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.

    See Teradata Archive/Recovery Utility Reference (B035-2412) for more information on online archive.

    Sessions (per stream) The default for the selected database is set in the Teradata tab of the TARA Server Configuration dialog box. A general rule is to have one session per amp being archived in the stream. An adequate number of parallel ARC sessions per stream are necessary to keep data moving. Too few sessions cause ARCMAIN to be the bottleneck during archival. Too many sessions waste resources because some of the sessions remain idle. Refer to Teradata Archive/Recovery Utility Reference (B035-2412) for more detail.
    Extra Options [Optional] Enter any ARCMAIN command line options that are not part of the GUI ARC build flow.
    Backup Application The default is NetBackup.
    Full Backup or

    Dictionary Only

    [Optional] Select Dictionary Only from the drop-down list to archive only the dictionary, or allow the Full Backup selection to archive the dictionary and data.

    If you choose Dictionary Only, specify only one stream per job.

    Use Catalog [Optional] Select Use Catalog to specify positioning data, so that when an object is restored, NetBackup can locate it without searching the entire tape.
    Verify Checksum [Optional] Verify Checksum verifies that what it is archiving or restoring is valid data. The checkbox is selected by default.
    Force online logging off [Optional] To stop online logging:

    Check the Online Backup box.

    Check the Force online logging off box.

    Normally, Teradata ARC allows online logging to continue even when a job fails or is aborted. Log files can become so large that subsequent attempts to archive the same database result in job failure.

    Turning online logging off avoids the problem of log files becoming too large if a job fails or is aborted.

    An ONLINE LOGOFF job is created and runs immediately after the parent job completes, except when the TARA server aborts the parent job because no connection could be made to stream 1 within 10 minutes. The ONLINE LOGOFF job is also aborted for connection failure after 10 minutes.

    The ONLINE LOGOFF job can be aborted from the GUI, regardless of its state.
    Character set The default is UTF-8. Select another character set if appropriate.
    Policies Click to display the Policy Selection dialog box. Select a policy group or an individual policy from the drop-down lists to use for this job.
    Other Buttons
    Save Click Save to accept the current script.
    Launch Click Launch to launch the job.
    Preview [Optional] Click Preview to open the Script Editor dialog box and display the job script. The job script can be edited, then saved. Click Launch to launch the job.
    Close Click Close to close the Script Options dialog box.