以下に、VERBOSEレベル1を指定した場合の出力例を示します。
進行報告行の構成と内容は、Teradata ARCの新しいリリースで特に断ることなく変更されます。 このため、以下の例をコピーしてスクリプトまたはプログラムを作成しないでください。
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