Teradata TPump Script Example - Parallel Data Pump

Teradata® Parallel Data Pump Reference

Product
Parallel Data Pump
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-11
dita:mapPath
dmq1512702641516.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-3021
lifecycle
previous
Product Category
Teradata Tools and Utilities

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'.