15.10 - Run the Teradata PT Job Script - Parallel Transporter

Teradata Parallel Transporter Quick Start Guide

Parallel Transporter
Programming Reference

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

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

DEFINE JOB qstart3

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

tbuild -f qstart3.txt -v jobvars3.txt -j qstart3



This tbuild option...

Takes the following argument...


Name of the script to be run: qstart3.txt


Name of the job variables file: jobvars3.txt

This is the job variables file you have edited.


Name of the job: qstart3

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 written to a target table that already has 10 rows. 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.10.00\Teradata Parallel Transporter/lo
Job id is qstart3-36, running on WUSLK121545-V5X
Teradata Parallel Transporter Update Operator Version
$UPDATE: private log specified: updateprivate.log
Teradata Parallel Transporter Export Operator Version
$EXPORT: private log specified: exportprivate.log
$UPDATE: connecting sessions
$EXPORT: connecting sessions
$UPDATE: preparing target table(s)
$UPDATE: entering DML Phase
$UPDATE: entering Acquisition Phase
$EXPORT: sending SELECT request
$EXPORT: entering End Export Phase
$EXPORT: Total Rows Exported:  10
$UPDATE: entering Application Phase
$UPDATE: Statistics for Target Table:  'TARGET_EMP_TABLE'
$UPDATE: Rows Inserted: 10
$UPDATE: Rows Updated:  0
$UPDATE: Rows Deleted:  0
$UPDATE: entering Cleanup Phase
$UPDATE: disconnecting sessions
$EXPORT: disconnecting sessions
$EXPORT: Total processor time used = '0.171601 Second(s)'
$EXPORT: Start : Fri May 20 14:01:36 2011
$EXPORT: End   : Fri May 20 14:01:48 2011
$UPDATE: Total processor time used = '0.171601 Second(s)'
$UPDATE: Start : Fri May 20 14:01:36 2011
$UPDATE: End   : Fri May 20 14:01:49 2011
Job step MAIN_STEP completed successfully
Job qstart3 completed successfully