Following is sample output that results from specifying VERBOSE level 1.
The organization and contents of informational progress report lines changes without notice with new releases of Teradata ARC. Therefore, do not develop scripts or programs that exactly copy this example.
07/09/2014 03:25:53 READING DEFAULTS FROM FILE=[SYSPARM] 07/09/2014 03:25:53 07/09/2014 03:25:53 Copyright 1989-2014, Teradata Corporation. 07/09/2014 03:25:53 All Rights Reserved. 07/09/2014 03:25:53 07/09/2014 03:25:53 *** **** **** 07/09/2014 03:25:53 * * * * * PROGRAM: ARCMAIN 07/09/2014 03:25:53 ***** **** * RELEASE: 15.10.00.00 07/09/2014 03:25:53 * * * * * BUILD: 150108I (Jun 19 2014) 07/09/2014 03:25:53 * * * * **** 07/09/2014 03:25:53 07/09/2014 03:25:53 PARAMETERS IN USE: 07/09/2014 03:25:53 07/09/2014 03:25:53 SESSIONS 80 07/09/2014 03:25:53 CHECKPOINT FREQUENCY CHANGED TO 5 07/09/2014 03:25:53 VERBOSE LEVEL 1 07/09/2014 03:25:53 NO HALT 07/09/2014 03:25:53 07/09/2014 03:25:53 07/09/2014 03:25:53 CHARACTER SET IN USE: EBCDIC 07/09/2014 03:25:53 LOGON TDSL/DBC,; 07/09/2014 03:25:54 LOGGED ON 2 SESSIONS 07/09/2014 03:25:55 07/09/2014 03:25:55 DBS LANGUAGE SUPPORT MODE Standard 07/09/2014 03:25:55 DBS RELEASE 15.10i.00.181 07/09/2014 03:25:55 DBS VERSION 15.10i.00.181 07/09/2014 03:25:55 07/09/2014 03:25:55 STATEMENT COMPLETED 07/09/2014 03:25:55 07/09/2014 03:25:55 07/09/2014 03:25:55 ARCHIVE DATA TABLES 07/09/2014 03:25:55 (SYSTEMFE), 07/09/2014 03:25:55 RELEASE LOCK, 07/09/2014 03:25:55 FILE = ARC1; 07/09/2014 03:25:56 UTILITY EVENT NUMBER - 35954 07/09/2014 03:26:13 LOGGED ON 80 SESSIONS 07/09/2014 03:26:13 07/09/2014 03:26:13 ARCHIVING DATABASE "SYSTEMFE" 07/09/2014 03:26:18 MACRO "AllRestarts" - ARCHIVED 07/09/2014 03:26:18 MACRO "BynetEvents" - ARCHIVED 07/09/2014 03:26:18 VIEW "CleanupQCF" - ARCHIVED 07/09/2014 03:26:18 --- Starting table "CleanupQCFVer" 07/09/2014 03:26:18 --- Table "CleanupQCFVer" is not a spanned object 07/09/2014 03:26:18 --- CHKPT: 2,063 bytes, 28 rows received 07/09/2014 03:26:18 --- Data subtable: 2,063 bytes, 28 rows received 07/09/2014 03:26:18 TABLE "CleanupQCFVer" - 2,063 BYTES, 28 ROWS ARCHIVED 07/09/2014 03:26:18 VIEW "CreateQCF" - ARCHIVED 07/09/2014 03:26:18 --- Starting table "CreateQCFVer" 07/09/2014 03:26:18 --- Table "CreateQCFVer" is not a spanned object 07/09/2014 03:26:18 --- CHKPT: 71,286 bytes, 523 rows received 07/09/2014 03:26:18 --- Data subtable: 71,286 bytes, 523 rows received 07/09/2014 03:26:18 TABLE "CreateQCFVer" - 71,286 BYTES, 523 ROWS ARCHIVED 07/09/2014 03:26:18 MACRO "DiskEvents" - ARCHIVED 07/09/2014 03:26:18 MACRO "EventCount" - ARCHIVED 07/09/2014 03:26:18 MACRO "FallBack_All" - ARCHIVED 07/09/2014 03:26:18 MACRO "FallBack_DB" - ARCHIVED 07/09/2014 03:26:18 MACRO "ListErrorCodes" - ARCHIVED 07/09/2014 03:26:18 MACRO "ListEvent" - ARCHIVED 07/09/2014 03:26:18 MACRO "ListRestart_Logon_Events" - ARCHIVED 07/09/2014 03:26:18 MACRO "ListSoftware_Event_Log" - ARCHIVED 07/09/2014 03:26:18 MACRO "MiniCylpacks" - ARCHIVED 07/09/2014 03:26:18 MACRO "NoFallBack_All" - ARCHIVED 07/09/2014 03:26:18 MACRO "NoFallBack_DB" - ARCHIVED 07/09/2014 03:26:18 --- Starting table "opt_cost_table" 07/09/2014 03:26:18 --- Table "opt_cost_table" is not a spanned object 07/09/2014 03:26:18 --- Data subtable: 7,400 bytes, 0 rows received 07/09/2014 03:26:18 TABLE "opt_cost_table" - 7,400 BYTES, 0 ROWS ARCHIVED 07/09/2014 03:26:18 --- Starting table "Opt_DBSCtl_Table" 07/09/2014 03:26:18 --- Table "Opt_DBSCtl_Table" is not a spanned object 07/09/2014 03:26:18 --- Data subtable: 620 bytes, 0 rows received 07/09/2014 03:26:18 TABLE "Opt_DBSCtl_Table" - 620 BYTES, 0 ROWS ARCHIVED 07/09/2014 03:26:18 --- Starting table "opt_ras_table" 07/09/2014 03:26:18 --- Table "opt_ras_table" is not a spanned object 07/09/2014 03:26:18 --- Data subtable: 8,646 bytes, 0 rows received 07/09/2014 03:26:18 TABLE "opt_ras_table" - 8,646 BYTES, 0 ROWS ARCHIVED 07/09/2014 03:26:18 --- Starting table "Opt_XMLPlan_Table" 07/09/2014 03:26:18 --- Table "Opt_XMLPlan_Table" is not a spanned object 07/09/2014 03:26:18 --- Data subtable: 750 bytes, 0 rows received 07/09/2014 03:26:18 TABLE "Opt_XMLPlan_Table" - 750 BYTES, 0 ROWS ARCHIVED 07/09/2014 03:26:18 MACRO "PackDisk" - ARCHIVED 07/09/2014 03:26:18 MACRO "ReconfigCheck" - ARCHIVED 07/09/2014 03:26:18 --- Starting table "Temp_ReconfigSpace" 07/09/2014 03:26:18 --- Table "Temp_ReconfigSpace" is not a spanned object 07/09/2014 03:26:18 --- Data subtable: 464 bytes, 0 rows received 07/09/2014 03:26:18 TABLE "Temp_ReconfigSpace" - 464 BYTES, 0 ROWS ARCHIVED 07/09/2014 03:26:18 "SYSTEMFE" - LOCK RELEASED 07/09/2014 03:26:18 DUMP COMPLETED 07/09/2014 03:26:18 STATEMENT COMPLETED 07/09/2014 03:26:18 07/09/2014 03:26:18 07/09/2014 03:26:18 RESTORE DATA TABLES 07/09/2014 03:26:18 (SYSTEMFE), 07/09/2014 03:26:18 RELEASE LOCK, 07/09/2014 03:26:18 FILE = ARC1; 07/09/2014 03:26:18 UTILITY EVENT NUMBER - 35957 07/09/2014 03:26:19 --- ARCHIVED AT 07-09-14 03:26:13 07/09/2014 03:26:19 --- ARCHIVED FROM ALL AMP DOMAINS 07/09/2014 03:26:19 --- UTILITY EVENT NUMBER IN ARCHIVE - 35954 07/09/2014 03:26:19 --- SOURCE RDBMS VERSION: LANGUAGE SUPPORT MODE:Standard; --- RELEASE:15.10i.00.181; VERSION:15.10i.00.181; 07/09/2014 03:26:20 STARTING TO RESTORE DATABASE "SYSTEMFE" 07/09/2014 03:26:24 "AllRestarts" - MACRO RESTORED 07/09/2014 03:26:24 "BynetEvents" - MACRO RESTORED 07/09/2014 03:26:24 "CleanupQCF" - VIEW RESTORED 07/09/2014 03:26:24 "CleanupQCFVer" - DICTIONARY ROWS RESTORED 07/09/2014 03:26:24 "CreateQCF" - VIEW RESTORED 07/09/2014 03:26:24 "CreateQCFVer" - DICTIONARY ROWS RESTORED 07/09/2014 03:26:24 "DiskEvents" - MACRO RESTORED 07/09/2014 03:26:24 "EventCount" - MACRO RESTORED 07/09/2014 03:26:24 "FallBack_All" - MACRO RESTORED 07/09/2014 03:26:24 "FallBack_DB" - MACRO RESTORED 07/09/2014 03:26:24 "ListErrorCodes" - MACRO RESTORED 07/09/2014 03:26:24 "ListEvent" - MACRO RESTORED 07/09/2014 03:26:24 "ListRestart_Logon_Events" - MACRO RESTORED 07/09/2014 03:26:24 "ListSoftware_Event_Log" - MACRO RESTORED 07/09/2014 03:26:24 "MiniCylpacks" - MACRO RESTORED 07/09/2014 03:26:24 "NoFallBack_All" - MACRO RESTORED 07/09/2014 03:26:24 "NoFallBack_DB" - MACRO RESTORED 07/09/2014 03:26:24 "opt_cost_table" - DICTIONARY ROWS RESTORED 07/09/2014 03:26:24 "Opt_DBSCtl_Table" - DICTIONARY ROWS RESTORED 07/09/2014 03:26:24 "opt_ras_table" - DICTIONARY ROWS RESTORED 07/09/2014 03:26:24 "Opt_XMLPlan_Table" - DICTIONARY ROWS RESTORED 07/09/2014 03:26:24 "PackDisk" - MACRO RESTORED 07/09/2014 03:26:24 "ReconfigCheck" - MACRO RESTORED 07/09/2014 03:26:24 "Temp_ReconfigSpace" - DICTIONARY ROWS RESTORED 07/09/2014 03:26:24 DICTIONARY RESTORE COMPLETED 07/09/2014 03:26:25 --- Starting table "CleanupQCFVer" 07/09/2014 03:26:25 --- Table "CleanupQCFVer" is not a deferred object 07/09/2014 03:26:26 "CleanupQCFVer" - 2,063 BYTES, 28 ROWS RESTORED 07/09/2014 03:26:26 --- Starting table "CreateQCFVer" 07/09/2014 03:26:26 --- Table "CreateQCFVer" is not a deferred object 07/09/2014 03:26:27 "CreateQCFVer" - 71,286 BYTES, 523 ROWS RESTORED 07/09/2014 03:26:27 --- Starting table "opt_cost_table" 07/09/2014 03:26:27 --- Table "opt_cost_table" is not a deferred object 07/09/2014 03:26:27 "opt_cost_table" - 7,400 BYTES, 0 ROWS RESTORED 07/09/2014 03:26:27 --- Starting table "Opt_DBSCtl_Table" 07/09/2014 03:26:27 --- Table "Opt_DBSCtl_Table" is not a deferred object 07/09/2014 03:26:27 "Opt_DBSCtl_Table" - 620 BYTES, 0 ROWS RESTORED 07/09/2014 03:26:27 --- Starting table "opt_ras_table" 07/09/2014 03:26:27 --- Table "opt_ras_table" is not a deferred object 07/09/2014 03:26:27 "opt_ras_table" - 8,646 BYTES, 0 ROWS RESTORED 07/09/2014 03:26:27 --- Starting table "Opt_XMLPlan_Table" 07/09/2014 03:26:27 --- Table "Opt_XMLPlan_Table" is not a deferred object 07/09/2014 03:26:27 "Opt_XMLPlan_Table" - 750 BYTES, 0 ROWS RESTORED 07/09/2014 03:26:27 --- Starting table "Temp_ReconfigSpace" 07/09/2014 03:26:27 --- Table "Temp_ReconfigSpace" is not a deferred object 07/09/2014 03:26:27 "Temp_ReconfigSpace" - 464 BYTES, 0 ROWS RESTORED 07/09/2014 03:26:27 --- Building fallback subtable for index 0. 07/09/2014 03:26:29 --- Clearing build flag for index 0. 07/09/2014 03:26:29 --- Building fallback subtable for index 0. 07/09/2014 03:26:30 --- Clearing build flag for index 0. 07/09/2014 03:26:30 --- Building fallback subtable for index 0. 07/09/2014 03:26:31 --- Clearing build flag for index 0. 07/09/2014 03:26:31 --- Building fallback subtable for index 0. 07/09/2014 03:26:32 --- Clearing build flag for index 0. 07/09/2014 03:26:33 --- Building fallback subtable for index 0. 07/09/2014 03:26:34 --- Clearing build flag for index 0. 07/09/2014 03:26:34 --- Building fallback subtable for index 0. 07/09/2014 03:26:35 --- Clearing build flag for index 0. 07/09/2014 03:26:35 --- Building fallback subtable for index 0. 07/09/2014 03:26:36 --- Clearing build flag for index 0. 07/09/2014 03:26:36 "SYSTEMFE" - LOCK RELEASED 07/09/2014 03:26:36 07/09/2014 03:26:36 STATEMENT COMPLETED 07/09/2014 03:26:36 07/09/2014 03:26:36 07/09/2014 03:26:36 LOGOFF; 07/09/2014 03:26:36 LOGGED OFF 82 SESSIONS 07/09/2014 03:26:36 STATEMENT COMPLETED 07/09/2014 03:26:36 07/09/2014 03:26:36 07/09/2014 03:26:36 ARCMAIN TERMINATED WITH SEVERITY 0