Syntax - Teradata Tools and Utilities

Teradata® Archive/Recovery Utility Reference

Product
Teradata Tools and Utilities
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-06-05
dita:mapPath
fac1527114221922.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
Product Category
Teradata Tools and Utilities


PLOG is the user-specified name for the Performance file. This is a separate file from the archive file and will be located in either the working directory or the path that is specified. See “Usage Notes" below for an example.

Each line of the Performance file contains a two-character record type followed by the data provided for this type, as shown in the following list.

BG <timestamp>
Beginning of performance log.
<IOPARM>
<IOPARM> is the list of parameters given in the IOPARM command-line option (if any).
EN <timestamp>
Indicates the end of the Teradata ARC job.
<exitcode>
<exitcode> is the final exit code returned by ARC.
ER <timestamp>
Indicates a warning, error, or failure by Teradata ARC.
<exitcode>
<exitcode> is the severity of the error (4 for warning, 8 for error, 12 for failure, and 16 for internal error).
<errorcode>
<errorcode> is the Teradata ARC or Teradata Database error code for the error.
<string>
<string> is the string output by Teradata ARC indicating the error.
LG <timestamp>
Displays the logon time given to Teradata ARC in the ARC script.
<logon-str>
Displays the logon string given to Teradata ARC in the ARC script.
OE <timestamp>
Indicates the end time for the named object.
<TS-end>
<TS-end> is the end time for the object.
<objtype>
<objtype> is the type of object (database-level, 'D', or table-level, 'T').
<name>
<name> is the name of the database (and table for table-level objects).
OS <timestamp>
Indicates the start time for the named object.
<objtype>
<objtype> is the type of object (database-level, 'D', or table-level, 'T').
<name>
<name> is the name of the database (and table for table-level objects).
ST <timestamp>
Displays the time of currently executing statement (from the ARC script).
<statement>
Displays the currently executing statement (from the ARC script).
TB <TS-begin>
Indicates the output at the end of archiving or restoring each table.
<TS-begin is the time the table started.
<TS-build>
<TS-build is the time the build process started.
<TS-end>
<TS-end> is the ending.
<bytes>
<bytes> is the number of bytes of data archived or restored.
<name>
<name> is the name of the database and table archived or restored.
VB <timestamp>
Indicates that a verbose message is output by Teradata ARC.
<string>
<string> is the message that is displayed.