The syntax of Teradata ARC control language is similar to Teradata SQL, that is, each statement is composed of words and delimiters and is terminated by a semicolon. Teradata ARC writes each statement (and a response to each statement) to an output file.
Note: For simplified descriptions of the Teradata ARC control language, refer to the Archive/Recovery chapter of the Teradata Tools and Utilities Command Summary, which provides only syntax diagrams and a brief description of the syntax variables for each Teradata client utility.
The Teradata ARC control statements perform these types of activities:
Table 19 summarizes Teradata ARC statements. For more detail, refer to the sections that follow the table.
Statement |
Activity |
Function |
Archive |
Reads an archive tape and displays content information |
|
Archive |
Archives a copy of database content to a client resident file in the specified format Beginning with TTU 13.00.00, there is support for archiving all objects as individual objects. |
|
Archive |
Builds indexes for data tables and fallback data for fallback tables |
|
Recovery |
Marks a journal table for later archive or recovery activities |
|
Archive |
Recreates copies of archived databases or objects; also restores archived files from one system to another Beginning with TTU 13.00.00, there is support for copying all objects as individual objects. Note: Triggers cannot be copied. |
|
Miscellaneous |
Deletes a partially restored database |
|
Recovery |
Deletes a saved or restored journal |
|
Security |
Specifies any additional logon or authentication data required by an extended security mechanism |
|
Archive |
Ends the online archive process |
|
Archive |
Begins the online archive process |
|
Security |
Sets the extended security mechanism used by Teradata ARC to log onto a Teradata Database |
|
Session Control |
Ends a Teradata session and terminates Teradata ARC |
|
Session Control |
Begins a Teradata session |
|
QUIT |
Session Control |
See LOGOFF |
Miscellaneous |
Releases a utility lock on a database or table |
|
Archive |
Restores objects from an archive file to specified AMPs Beginning with TTU 13.00.00, there is support for restoring all objects as individual objects. |
|
Archive |
Validates referenced indexes that have been marked inconsistent during restore |
|
Recovery |
Restores a database or tables to a state that existed before some change |
|
Recovery |
Restores a database or tables to its (their) state following a change |
|
Miscellaneous |
Provides values for a session to precisely identify the origins of a query. |