15.00 - Run the Teradata PT Job Script - Parallel Transporter

Teradata Parallel Transporter Quick Start Guide

Parallel Transporter
User Guide

Run the Teradata PT Job Script

The following is the Teradata PT job script you will be running.

DEFINE JOB qstart1

The script is saved as qstart1.txt in the quickstart sample directory.

To run the job script, execute the following Teradata PT command in the command window:

tbuild -f qstart1.txt -v jobvars1.txt -j qstart1



This tbuild option...

Takes the following argument...


Name of the script to be run: qstart1.txt


Name of the job variables file: jobvars1.txt

This is the job variables file you have edited.


Name of the job: qstart1

RESULT: Once you have run the tbuild command loading data into the target table, you will see the following output on the console, confirming that 10 rows have been loaded. The console output may contain a DBS 3807 warning. You can ignore this message. For more information, see the ErrorList operator attribute in the DDL Operator chapter of the Teradata Parallel Transporter Reference.

. . .

Teradata Parallel Transporter Version
Job log: C:\Program Files\Teradata\client\15.00.00\Teradata Parallel Transporter/lo
Job id is qstart1-32, running on WUSLK121545-V5X
Teradata Parallel Transporter Load Operator Version
$LOAD: private log specified: loadprivate.log
Teradata Parallel Transporter DataConnector Version
$FILE_READER: TPT19008 DataConnector Producer operator Instances: 1
$FILE_READER: TPT19003 ECI operator ID: $FILE_READER-6024
$FILE_READER: TPT19222 Operator instance 1 processing file 'flatfile1.dat'.
$LOAD: connecting sessions
$LOAD: preparing target table
$LOAD: entering Acquisition Phase
$LOAD: entering Application Phase
$LOAD: Statistics for Target Table:  'TARGET_EMP_TABLE'
$LOAD: Total Rows Sent To RDBMS:      10
$LOAD: Total Rows Applied:            10
$LOAD: disconnecting sessions
$FILE_READER: TPT19221 Total files processed: 1.
$LOAD: Total processor time used = '0.218401 Second(s)'
$LOAD: Start : Fri May 20 13:53:00 2011
$LOAD: End   : Fri May 20 13:53:09 2011
Job step MAIN_STEP completed successfully
Job qstart1 completed successfully