The sample scripts below can be used to validate Teradata ARC.
LOGON DBCID/USERID,PASSWORD;
ARCHIVE DATA TABLES (CRASHDUMPS) ,
RELEASE LOCK,
FILE=ARCHIVE;
LOGOFF;
Note: The user needs to modify DBCID, USERID, and PASSWORD in the archive script accordingly before executing the script.
The above archive script performs a backup of user/database CRASHDUMPS and terminates
with return code 0 as shown in the following sample output.
Sample Output: Archive
08/06/2014 08:20:32 ARCHIVE DATA TABLES (CRASHDUMPS),
08/06/2014 08:20:32 RELEASE LOCK,
08/06/2014 08:20:32 FILE=ARCHIVE;
08/06/2014 08:20:32 UTILITY EVENT NUMBER - 2580
08/06/2014 08:20:32 LOGGED ON 4 SESSIONS
08/06/2014 08:20:32
08/06/2014 08:20:32 ARCHIVING DATABASE “CRASHDUMPS”
08/06/2014 08:20:33 “CRASHDUMPS” - LOCK RELEASED
08/06/2014 08:20:33 DUMP COMPLETED
08/06/2014 08:20:33 STATEMENT COMPLETED
08/06/2014 08:20:33
08/06/2014 08:20:33 LOGOFF;
08/06/2014 08:20:33 LOGGED OFF 6 SESSIONS
08/06/2014 08:20:33 STATEMENT COMPLETED
08/06/2014 08:20:33
08/06/2014 08:20:33
08/06/2014 08:20:33 ARCMAIN TERMINATED WITH SEVERITY 0
LOGON DBCID/USERID,PASSWORD;
RESTORE DATA TABLES (CRASHDUMPS),
RELEASE LOCK,
FILE=ARCHIVE;
LOGOFF;
Note: The user needs to modify DBCID, USERID, and PASSWORD in the restore script accordingly before executing the script.
The above restore script performs a restore of user/database CRASHDUMPS and terminates
with return code 0 as shown in the following sample output.
Sample Output: Restore
08/06/2014 08:23:34 RESTORE DATA TABLES (CRASHDUMPS),
08/06/2014 08:23:34 RELEASE LOCK,
08/06/2014 08:23:34 FILE=ARCHIVE;
08/06/2014 08:23:34 UTILITY EVENT NUMBER - 2581
08/06/2014 08:23:35 LOGGED ON 4 SESSIONS
08/06/2014 08:23:35 STARTING TO RESTORE DATABASE “CRASHDUMPS”
08/06/2014 08:23:35 DICTIONARY RESTORE COMPLETED
08/06/2014 08:23:35 “CRASHDUMPS” - LOCK RELEASED
08/06/2014 08:23:35
08/06/2014 08:23:35 STATEMENT COMPLETED
08/06/2014 08:23:35
08/06/2014 08:23:35 LOGOFF;
08/06/2014 08:23:35 LOGGED OFF 6 SESSIONS
08/06/2014 08:23:35 STATEMENT COMPLETED
08/06/2014 08:23:35
08/06/2014 08:23:35
08/06/2014 08:23:35 ARCMAIN TERMINATED WITH SEVERITY 0