The following table summarizes Teradata ARC statements. For more detail, refer to the sections that follow the table.
| Statement | Activity | Function |
|---|---|---|
| ANALYZE | Archive | Reads an archive tape and displays content information. |
| ARCHIVE | 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. |
| BUILD | Archive | Builds indexes for data tables and fallback data for fallback tables. |
| CHECKPOINT | Recovery | Marks a journal table for later archive or recovery activities. |
| COPY | 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. Triggers cannot be copied.
|
| DELETE DATABASE | Miscellaneous | Deletes a partially restored database. |
| DELETE JOURNAL | Recovery | Deletes a saved or restored journal. |
| LOGDATA | Security | Specifies any additional logon or authentication data required by an extended security mechanism. |
| LOGGING ONLINE ARCHIVE OFF | Archive | Ends the online archive process. |
| LOGGING ONLINE ARCHIVE ON | Archive | Begins the online archive process. |
| LOGMECH | Security | Sets the extended security mechanism used by Teradata ARC to log onto a Teradata Database. |
| LOGOFF | Session Control | Ends a Teradata session and terminates Teradata ARC. |
| LOGON | Session Control | Begins a Teradata session. |
| QUIT | Session Control | See LOGOFF |
| RELEASE LOCK | Miscellaneous | Releases a utility lock on a database or table. |
| RESTORE | 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. |
| REVALIDATE REFERENCES FOR | Archive | Validates referenced indexes that have been marked inconsistent during restore. |
| ROLLBACK | Recovery | Restores a database or tables to a state that existed before some change. |
| ROLLFORWARD | Recovery | Restores a database or tables to its (their) state following a change. |
| SET QUERY_BAND | Miscellaneous | Provides values for a session to precisely identify the origins of a query. |