The following example shows what a simple Teradata TPump script and its corresponding output might look like. The lines that begin with 4-digit numbers (for example, 0001) are scripts, the rest are output.
======================================================================== = = = Teradata Parallel Data Pump Utility Release 16.20.00.00 = = Platform WIN32 = = PID 5836 = = = ======================================================================== = = = Copyright 1997-2017 Teradata Corporation. ALL RIGHTS RESERVED. = = = ======================================================================== **** 15:30:21 UTY2411 Processing start date: THU SEP 21, 2017 ======================================================================== = = = Logon/Connection = = = ======================================================================== 0001 .LOGTABLE TESTPSALOGS; 0002 .LOGON NODEID/FLUSER,; **** 15:30:21 UTY8400 Teradata Database Release: 16.20.00.00 **** 15:30:21 UTY8400 Teradata Database Version: 16.20.00.00 **** 15:30:21 UTY8400 Default character set: ASCII **** 15:30:21 UTY8400 Current RDBMS has UDT support **** 15:30:21 UTY8400 Current RDBMS has Large Decimal support **** 15:30:21 UTY8400 Current RDBMS has Statement Info Parcel support **** 15:30:21 UTY8400 Maximum supported buffer size: 1M **** 15:30:21 UTY8400 Upsert supported by RDBMS server **** 15:30:21 UTY8400 Data Encryption supported by RDBMS server **** 15:30:21 UTY8400 Array Support supported by RDBMS server **** 15:30:21 UTY8400 Statement Independence supported by RDBMS server **** 15:30:22 UTY6211 A successful connect was made to the RDBMS. **** 15:30:22 UTY6217 Logtable 'FLUSER.TESTPSALOGS' has been created. ======================================================================== = = = Processing Control Statements = = = ======================================================================== 0003 delete from TESTSA01; **** 15:30:23 UTY1016 'DELETE' request successful. 0004 .SET WEDDT TO '2017-05-02'; 0005 .DISPLAY '&WEDDT' TO FILE *; **** 15:30:23 UTY2402 Previous statement modified to: 0006 .DISPLAY '2017-05-02' TO FILE *; 2017-05-02 0007 .DISPLAY '2017-05-02' TO FILE *; 2017-05-02 0008 .BEGIN CHECKPOINT 15 SESSIONS 4 1 TENACITY 2 ERRORTABLE TPERRTESTSA01 ROBUST OFF; ======================================================================== = = = Processing TPump Statements = = = ======================================================================== 0009 .LAYOUT LAY0012; 0010 .FIELD FF1 * INTEGER KEY; 0011 .FIELD FF2 * CHAR(10); 0012 .FIELD FF3 * CHAR(10); 0013 .DML LABEL LABEL0012; 0014 INSERT INTO TESTSA01 VALUES ( :FF1, :FF2, :FF3 ); 0015 .IMPORT INFILE FEXPDATA LAYOUT LAY0012 APPLY LABEL0012; 0016 .END LOAD; **** 15:30:24 UTY6609 Starting to log on sessions... **** 15:30:28 UTY6610 Logged on 4 sessions. ======================================================================== = = = TPump Import(s) Beginning = = = ======================================================================== **** 15:30:28 UTY6630 Options in effect for following TPump Import(s): . Tenacity: 2 hour limit to successfully connect load sessions. . Max Sessions: 4 session(s). . Min Sessions: 1 session(s). . Checkpoint: 15 minute(s). . Errlimit: No limit in effect. . Restart Mode: SIMPLE. . Serialization: OFF. . Packing: 20 Statements per Request. . StartUp Rate: UNLIMITED Statements per Minute. **** 15:30:32 UTY8802 WARNING: Rate Monitoring turned off - database TPumpMacro does not exist. **** 15:30:32 UTY6608 Import 1 begins. **** 15:30:32 UTY6641 Since last chkpt., 5 recs. in, 5 stmts., 1 reqs **** 15:30:32 UTY6647 Since last chkpt., avg. DBS wait time: 312.00 **** 15:30:32 UTY6612 Beginning final checkpoint... **** 15:30:32 UTY6641 Since last chkpt., 5 recs. in, 5 stmts., 1 reqs **** 15:30:32 UTY6647 Since last chkpt., avg. DBS wait time: 312.00 **** 15:30:33 UTY6607 Checkpoint Completes with 5 rows sent. **** 15:30:33 UTY6642 Import 1 statements: 5, requests: 1 **** 15:30:33 UTY6643 Import 1 average statements per request: 5.00 **** 15:30:33 UTY6644 Import 1 average statements per record: 1.00 **** 15:30:33 UTY6645 Import 1 statements/session: avg. 1.25, min. 0.00, max. 5.00 **** 15:30:33 UTY6646 Import 1 requests/session: average 0.25, minimum 0.00, maximum 1.00 **** 15:30:33 UTY6648 Import 1 DBS wait time/session: avg. 78.00, min. 0.00, max. 312.00 **** 15:30:33 UTY6649 Import 1 DBS wait time/request: avg. 78.00, min. 0.00, max. 312.00 **** 15:30:33 UTY1823 Import processing statistics . IMPORT 1 Total thus far . ========= ============== Candidate records considered:.... 5 5 Apply conditions satisfied:...... 5 5 Records logable to error table:.. 0 0 Candidate records rejected:...... 0 0 **** Statistics for Apply Label : LABEL0012 Type: I Database: FLUSER Table or Macro Name: TESTSA01 Activity: 5 **** 15:30:33 UTY6677 Loading phase statistics Elapsed time: 00:00:00:01(dd:hh:mm:ss) CPU time: 0 Seconds MB/sec: 0.00012 MB/cpusec: N/A **** 15:30:34 UTY0821 Error table FLUSER.TPERRTESTSA01 is EMPTY, dropping table. ======================================================================== = = = Logoff/Disconnect = = = ======================================================================== **** 15:30:37 UTY6216 The restart log table has been dropped. **** 15:30:37 UTY6212 A successful disconnect was made from the RDBMS. **** 15:30:37 UTY2410 Total processor time used = '0.436803 Seconds' . Start : 15:30:16 - TUE MAY 02, 2017 . End : 15:30:37 - TUE MAY 02, 2017 . Highest return code encountered = '0'.