-
In the left and right panes of the ARCHIVE object selection dialog box are database objects. To archive a database, highlight or select the box next to the database in the left pane.
The tables of the database to be archived appear in the right pane.
-
Click on a level in the left pane.
The database and tables appear in the right pane. The following screen capture shows a database with a hierarchical view.
-
[Optional] To specify Partitioned Primary Index (PPI) options
for a table:
- Right-click on a table in the right pane.
- Click Options. A dialog box with a PPI options tab opens.
-
Click on one of the radio buttons:
- Full table, which is the default, archives the entire table
-
Selected Partitions archives the specified partitions
All Partitions is not valid for archive operations.
Other PPI Options is not valid for archive operations.
-
From the ARCHIVE object selection File menu, click Build ARC script or
.
-
Select database objects, then confirm the selection by clicking
OK in the Selection dialog box.
The Script Options dialog box appears.
-
Select options shown in the following table.
Option Description Job Name Entries in Job Name are case-sensitive. A job name must not contain any spaces, or these characters: <
>
~
"
*
,
?
\
/
The maximum length of the job name for Archive and Restore scripts is 220 characters. If this limit is exceeded, an error message requests that the job name be re-entered.
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, 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. IOTRACE=5, a debug parameter that ARCMAIN uses to enable a level of tracing, is the default. 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 the data being archived is valid. The checkbox is selected by default. However, the overhead of error checking slows the archive process. To improve performance, clear the checkbox. Job scripts created prior to clearing the Verify Checksum box have the verify checksum feature enabled 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. In the dialog box, select a specific policy for each stream from Manual Policy Selection. Alldefined policies are listed in Manual Policy Selection, not only the policies assigned to the default policy group. 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. -
Click Save, then
Launch.
The Teradata Tiered Archive/Restore Architecture dialog box displays the launched job and job streams. Conditions for each stream appear in the State column.
- ARCHIVE (B) - Build phase (only for restore operations)
- ARCHIVE (D) - Dictionary (for archive and restore operations)
- ARCHIVE (T) - Table Data (for archive and restore operations)
