Task 4: Evaluate a Completed Teradata PT Easy Loader Job - Parallel Transporter

Task 4: Evaluate a Completed Teradata PT Easy Loader Job

You can evaluate a completed Teradata PT Easy Loader job just as you evaluate a Teradata PT job.

Procedure 1: Examine Exit Codes

Each Teradata PT job returns an exit code upon job completion, which indicates job success or failure.

1 Examine the job exit code, which appears on the screen where you launched the job.

Exit Code	Description.
0	Completed successfully.
4	Completed successfully, but issued one or more warnings.
8	Terminated due to a user error, such as a syntax error.
12	Terminated due to a fatal error. A fatal error is any error other than a user error.

2 Determine whether or not further action is required.

If the exit code is 0, the job was successful and no further action is required.

If the exit code is 4, you can check the logs to examine the warning(s) and determine whether or not you should revise the area of the script that generated the warning to avoid a possible future failure.

If the exit code is 8 or 12, revise the script to correct the error.

3 For jobs that return an exit code that requires examination of the job logs “Examine the Teradata PT Job Log” immediately below.

Procedure 2: Examine the Teradata PT Job Logs

Examine the job logs to understand the details of how the job executed, what warnings were issued, and if the job failed, which errors caused the failure.

Types of Log	Explanation
Console	The console log displays messages in the Command window where the tbuild command was issued. This log contains high-level information about Teradata PT operators and infrastructure. It updates continuously while the job runs.
Public	The public log contains general information about the job. Use the tlogview command to access this log.
Private	The private log contains job performance metadata and a log of the activities and errors for each operator defined in the job. Use the tlogview command to access this log.

Procedure 3: Examine the Teradata PT Error Tables, If Applicable

Error tables provide information on Teradata Database errors encountered while writing data to the database, as well as detailed information about errors initially presented in the job logs.

If you have set error tables as attributes in your job script, examine the error tables. There are two types of error tables.

Error Table	Name of Table	Explanation
1	Acquisition	Exports constraint violations, bad data, and data conversion errors
2	Application	Contains any rows that cause violations of the unique primary index, for instance, duplicate rows. This error table is not used when the target table has a nonunique primary index.

Reference Information

Information on...	Is available in...
exit codes	“Chapter 10 Post-Job Considerations” on page 153
job steps	“Chapter 2 Teradata PT Job Components” on page 41
specifying checkpoint intervals	“Chapter 8 Launching a Job” on page 139
accessing public job logs and how to read them, including example logs	“Chapter 10 Post-Job Considerations” on page 153
accessing private job logs and how to read them, including example logs	“Chapter 10 Post-Job Considerations” on page 153
accessing the error tables and how to read them, including example tables	“Chapter 10 Post-Job Considerations” on page 153
the tlogview command	“Accessing and Using Job Logs” on page 155 See also “Teradata PT Utility Commands” in Teradata Parallel Transporter Reference.
strategies for evaluating a successful job	“Chapter 10 Post-Job Considerations” on page 153