All Forums Tools
navanomula 3 posts Joined 10/11
06 Jun 2012
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
 
+---------+---------+---------+---------+---------+--- ------+---------+----

feinholz 1234 posts Joined 05/08
11 Jun 2012

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

You must sign in to leave a comment.