The VERBOSE parameter directs Teradata ARC progress status information to the standard output device (for example, SYSPRINT for IBM platforms). The amount of status information sent is determined by the level specified in the parameter.
where:
|
Syntax Element |
Definition |
|
n |
Level of program status information sent to the standard output device, where n represents 2 or 3 VERBOSE without an n value provides the lowest level of status information. The amount of process status information sent to standard output increases with a higher n value. |
Progress status report is displayed on a standard output device. On the IBM mainframe platform, the progress status is sent to the SYSPRINT DD with other regular Teradata ARC output lines.
VERBOSE provides three levels of progress status (1 through 3):
VERBOSE, VERB or VB
Level 2 - VERBOSE2, VERB2 or VB2
Level 3 - VERBOSE3, VERB3 or VB3
While VERBOSE level 1 is designed for normal operation, the other two levels are for diagnosis and debugging. The performance of Teradata ARC is affected when these higher VERBOSE levels are used, especially if a low CHECKPOINT value is specified.
The output of VERBOSE is preceded by three dashes (---) for easy identification and filtering by other utilities.
For ARCHIVE and RESTORE/COPY operations, the amount of data processed in the data phase is displayed at each checkpoint. Teradata ARC internally takes checkpoints for every n number of data blocks processed for restart purposes. Therefore, it is possible to control the frequency of display of status information when VERBOSE is specified by the CHECKPOINT parameter setting. See “CHECKPOINT” on page 115.
For the RESTORE/COPY operations, each build request is displayed in addition to the data processed before the request is sent to the Teradata Database. However, the client has no control of the actual build execution. Therefore, after the request is sent, Teradata ARC waits for the completion of the build request.
Specify NOVERBOSE to disable the VERBOSE parameter. The default is NOVERBOSE.
Following is sample output that results from specifying VERBOSE level 1.
Note: 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