TPT log file not printing the update row count

Tools

TPT log file not printing the update row count

I have a TPT load script that does Delete table1, Insert table1, update_table2 and insert_table2. It writes two log files. In both of those log files we come to know how many rows got inserted. But it is not printing how many rows got updated. Is there any way that I can do to print update row count in log file. Below is my logfile:

+---------+---------+---------+---------+---------+---------+---------+----

run_

now remove HEADER_TEST1.tpt_gen_temp.sh

Leaving makeTempTPT function

Teradata Parallel Transporter Version 13.10.00.04

Job log: HEADER_TEST1-1500.out

Job id is HEADER_TEST1-1500, running on pm4003

Teradata Parallel Transporter SQL DDL Operator Version 13.10.00.04

DDL_OPERATOR: private log not specified

DDL_OPERATOR: connecting sessions

DDL_OPERATOR: sending SQL requests

DDL_OPERATOR: Rows Deleted:  5663

DDL_OPERATOR: disconnecting sessions

DDL_OPERATOR: Total processor time used = '0.022148 Second(s)'

DDL_OPERATOR: Start : Wed Jun  6 16:53:52 2012

DDL_OPERATOR: End   : Wed Jun  6 16:53:52 2012

Job step DELETE_TARGET completed successfully

Teradata Parallel Transporter DataConnector Version 13.10.00.04

DATA_CONNECTOR: TPT19008 DataConnector Producer operator Instances: 1

DATA_CONNECTOR: TPT19003 ECI operator ID: DATA_CONNECTOR-1363986

Teradata Parallel Transporter Update Operator Version 13.10.00.03

SQL_LOAD: private log not specified

DATA_CONNECTOR: TPT19222 Operator instance 1 processing file 'schema_header.txt'.

SQL_LOAD: connecting sessions

SQL_LOAD: preparing target table(s)

SQL_LOAD: entering DML Phase

SQL_LOAD: entering Acquisition Phase

SQL_LOAD: entering Application Phase

SQL_LOAD: Statistics for Target Table:  'HEADER'

SQL_LOAD: Rows Inserted: 5663

SQL_LOAD: Rows Updated:  0

SQL_LOAD: Rows Deleted:  0


SQL_LOAD: entering Cleanup Phase

SQL_LOAD: disconnecting sessions

DATA_CONNECTOR: TPT19221 Total files processed: 1.

SQL_LOAD: Total processor time used = '0.115943 Second(s)'

SQL_LOAD: Start : Wed Jun  6 16:53:53 2012

SQL_LOAD: End   : Wed Jun  6 16:54:11 2012

Job step load_data completed successfully

Teradata Parallel Transporter SQL DDL Operator Version 13.10.00.04

DDL_OPERATOR: private log not specified

DDL_OPERATOR: connecting sessions

DDL_OPERATOR: sending SQL requests

DDL_OPERATOR: disconnecting sessions

DDL_OPERATOR: Total processor time used = '0.020747 Second(s)'

DDL_OPERATOR: Start : Wed Jun  6 16:54:12 2012

DDL_OPERATOR: End   : Wed Jun  6 16:54:13 2012

Job step UPDATE_TARGET completed successfully

Teradata Parallel Transporter SQL DDL Operator Version 13.10.00.04

DDL_OPERATOR: private log not specified

DDL_OPERATOR: connecting sessions

DDL_OPERATOR: sending SQL requests

DDL_OPERATOR: Rows Inserted: 0

DDL_OPERATOR: disconnecting sessions

DDL_OPERATOR: Total processor time used = '0.02402 Second(s)'

DDL_OPERATOR: Start : Wed Jun  6 16:54:14 2012

DDL_OPERATOR: End   : Wed Jun  6 16:54:15 2012

Job step INSERT_TARGET completed successfully

Job HEADER_TEST1 completed successfully

try to rm temp_tpt

BTEQ 13.10.00.02 Wed Jun  6 16:54:20 2012

+---------+---------+---------+---------+---------+---------+---------+----

1 REPLY
Teradata Employee

Re: TPT log file not printing the update row count

Without seeing the entire script, it is hard to tell what you are actually trying to do. The console output (you are showing the console output, not the contents of the log) shows what was actually executed.

I would need to see the script and the DML statements.

-- SteveF