Teradata TPump Script Example
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 15.00.00.000 =
= Platform MVS =
= PID 33558028 =
= =
========================================================================
= =
= Copyright 1997-2014 Teradata Corporation. ALL RIGHTS RESERVED. =
= =
========================================================================
**** 03:56:39 UTY2411 Processing start date: FRI JAN 10, 2014
========================================================================
= =
= Logon/Connection =
= =
========================================================================
0001 .LOGTABLE TESTPSALOG;
0002 .LOGON TDSL/weekly,;
**** 03:56:39 UTY8400 Teradata Database Release: 15.00.00.00
**** 03:56:39 UTY8400 Teradata Database Version: 15.00.00.00
**** 03:56:39 UTY8400 Default character set: EBCDIC
**** 03:56:39 UTY8400 Current RDBMS has UDT support
**** 03:56:39 UTY8400 Current RDBMS has Large Decimal support
**** 03:56:39 UTY8400 Maximum supported buffer size: 1M
**** 03:56:39 UTY8400 Upsert supported by RDBMS server
**** 03:56:39 UTY8400 Array Support supported by RDBMS server
**** 03:56:39 UTY8400 Statement Independence supported by RDBMS server
**** 03:56:39 UTY6211 A successful connect was made to the RDBMS.
**** 03:56:39 UTY6217 Logtable 'WEEKLY.TESTPSALOG' has been created.
========================================================================
= =
= Processing Control Statements =
= =
========================================================================
0003 delete from TESTSA01;
**** 03:56:39 UTY1016 'DELETE' request successful.
0004 .SET WEDDT TO '2013-07-31';
0005 .DISPLAY '&WEDDT' TO FILE *;
**** 03:56:39 UTY2402 Previous statement modified to:
0006 .DISPLAY '2013-07-31' TO FILE *;
0007 .BEGIN
CHECKPOINT 15
SESSIONS 4 1
TENACITY 2
ERRORTABLE TPERRTESTSA01
ROBUST OFF;
========================================================================
= =
= Processing TPump Statements =
= =
========================================================================
00008 .LAYOUT LAY0012;
0009 .FIELD FF1 * INTEGER KEY;
0010 .FIELD FF2 * CHAR(10);
0011 .FIELD FF3 * CHAR(10);
00012 .DML LABEL LABEL0012;
0013 INSERT INTO TESTSA01 VALUES ( :FF1, :FF2, :FF3 );
00014 .IMPORT INFILE FEXPDATA
LAYOUT LAY0012
APPLY LABEL0012;
0015 .END LOAD;
**** 03:56:39 UTY6609 Starting to log on sessions...
**** 03:56:40 UTY6610 Logged on 4 sessions.
========================================================================
= =
= TPump Import(s) Beginning =
= =
========================================================================
**** 03:56:40 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.
**** 03:56:40 UTY8802 WARNING: Rate Monitoring turned off - database TPumpMacro
does not exist.
**** 03:56:40 UTY6608 Import 1 begins.
**** 03:56:41 UTY6641 Since last chkpt., 5 recs. in, 5 stmts., 1 reqs
**** 03:56:41 UTY6647 Since last chkpt., avg. DBS wait time: 203.00
**** 03:56:41 UTY6612 Beginning final checkpoint...
**** 03:56:41 UTY6641 Since last chkpt., 5 recs. in, 5 stmts., 1 reqs
**** 03:56:41 UTY6647 Since last chkpt., avg. DBS wait time: 203.00
**** 03:56:41 UTY6607 Checkpoint Completes with 0 rows sent.
**** 03:56:41 UTY6642 Import 1 statements: 5, requests: 1
**** 03:56:41 UTY6643 Import 1 average statements per request: 5.00
**** 03:56:41 UTY6644 Import 1 average statements per record: 1.00
**** 03:56:41 UTY6645 Import 1 statements/session: avg. 1.25, min. 0.00, max.
5.00
**** 03:56:41 UTY6646 Import 1 requests/session: average 0.25, minimum 0.00,
maximum 1.00
**** 03:56:41 UTY6648 Import 1 DBS wait time/session: avg. 50.75, min. 0.00,
max. 203.00
**** 03:56:41 UTY6649 Import 1 DBS wait time/request: avg. 50.75, min. 0.00,
max. 203.00
**** 03:56:41 UTY1803 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: WEEKLY
Table or Macro Name: TESTSA01
Activity: 5
**** 03:56:41 UTY6677 Loading phase statistics
Elapsed time: 00:00:00:01(dd:hh:mm:ss)
CPU time: 0.004245 Seconds
MB/sec: 0.00012
MB/cpusec: 0.0282686
**** 03:56:41 UTY0821 Error table WEEKLY.TPERRTESTSA01 is EMPTY, dropping
table.
0016 .LOGOFF;
========================================================================
= =
= Logoff/Disconnect =
= =
========================================================================
**** 03:56:42 UTY6216 The restart log table has been dropped.
**** 03:56:42 UTY6212 A successful disconnect was made from the RDBMS.
**** 03:56:42 UTY2410 Total processor time used = '0.098822 Seconds'
. Start : 03:56:39 - FRI JAN 10, 2014
. End : 03:56:42 - FRI JAN 10, 2014
. Highest return code encountered = '0'.