15.00 - Teradata TPump Script Example - Parallel Data Pump

Teradata Parallel Data Pump Reference

prodname
Parallel Data Pump
vrm_release
15.00
category
Programming Reference
featnum
B035-3021-034K

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