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

Teradata Parallel Transporter User Guide

prodname
Parallel Transporter
vrm_release
15.10
category
User Guide
featnum
B035-2445-035K

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