16.10 - Job Output Example - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)

The following is an example of the job’s output:

===================================================================
=                                                                 =
=                  TERADATA PARALLEL TRANSPORTER                  =
=                                                                 =
=            ERROR TABLE EXTRACTION VERSION 16.10.00.00           =
=                                                                 =
=   COPYRIGHT 2014, TERADATA CORPORATION. ALL RIGHTS RESERVED.    =
=                                                                 =
===================================================================

**** 13:04:26 Processing starting at: Fri Feb 22 13:04:26 2016

===================================================================
=                                                                 =
=                      Module Identification                      =
=                                                                 =
===================================================================
ERROR TABLE EXTRACTOR for Linux release 2.6.16.60-0.91.TDC.1.R.2-smp
on machine
ErtblMain : 16.10.00.01
ErtblCLI  : 16.10.00.03
ErtblMsgs : 16.10.00.01
ErtblUtil : 16.10.00.02
PXICU     : 16.10.00.00
TDICU     : 16.10.00.00
USelDir   : 16.10.00.00
CLIv2     : 16.10.00.00

===================================================================
=                                                                 =
=                Command Line Argument Information                =
=                                                                 =
===================================================================

**** 13:04:26 The user specified the following command line arguments:

-h tdpid -u user -p <not displayable> -t SAMPLE_ERRTABLE1 -n 10

===================================================================
=                                                                 =
=                           Job Options                           =
=                                                                 =
===================================================================

**** 13:04:26 Options in effect for this job:
Output file:            'SAMPLE_ERRTABLE1.txt'
Output limit:           No limit in effect
Record format:          'DELIMITED'
Text delimiter:         '|'
Quoted fields:          'N' (Y for Yes, N for No)

===================================================================
=                                                                 =
=                       Session Connection                        =
=                                                                 =
===================================================================

Connecting to RDBMS:       'tdpid'
Connecting with UserId:    'user'
Session character set:     'ASCII'

**** 13:04:26 Connecting a session
**** 13:04:27 Session connected

===================================================================
=                                                                 =
=                  Teradata Database Information                  =
=                                                                 =
===================================================================

**** 13:04:27 Teradata Database Version: '16.10.00.00      '
**** 13:04:27 Teradata Database Release: '16.10.00.00      '

===================================================================
=                                                                 =
=                     Error Table Information                     =
=                                                                 =
===================================================================

Error table: 'SAMPLE_ERRTABLE1'
Number of columns sent to RDBMS in the original load job: 10

**** 13:04:27 The error table is a FastLoad protocol error table
**** 13:04:27 The endianness of the error data in the error table is 
     little-endian

===================================================================
=                                                                 =
=                    Selecting The Error Table                    =
=                                                                 =
===================================================================

**** 13:04:27 This job is submitting the following request:
SELECT CAST(ERRORFIELDNAME AS VARCHAR(128)),CAST(ERRORCODE AS 
VARCHAR(10)),DATAPARCEL FROM SAMPLE_ERRTABLE1 ORDER BY ERRORCODE;

**** 13:04:27 The request has been completed
**** 13:04:27 Number of row(s) returned: 40

**** 13:04:27 Starting to retrieve data from the RDBMS
**** 13:04:27 Finished retrieving data

**** 13:04:27 Number of row(s) writtten to the output file: 40

===================================================================
=                                                                 =
=                        Logoff/Disconnect                        =
=                                                                 =
===================================================================

**** 13:04:27 Disconnecting session
**** 13:04:27 Session disconnected

   **** 13:04:27 Total processor time used = '0.06 Second(s)'
   .    Start : Fri Jul 15 13:04:26 2016
   .    End   : Fri Jul 15 13:04:27 2016
   .    Highest return code encountered = '0'.
**** 13:04:27 This job terminated
The output sample above is for example purposes only. Your output will be different.