17.00 - Sample Output - Parallel Data Pump

Teradata® Parallel Data Pump Reference

prodname
Parallel Data Pump
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-3021-220K

The following is a sample output when ".DEBUG TRACE LOAD" is specified in TPump script:

     ========================================================================
     =                                                                      =
     =          Teradata Parallel Data Pump Utility    Release 17.00.00.00  =
     =          Platform WIN 64-bit                                         =
     =          PID      10948                                              =
     =                                                                      =
     ========================================================================
     =                                                                      =
     =     Copyright 1997-2019 Teradata Corporation. ALL RIGHTS RESERVED.   =
     =                                                                      =
     ========================================================================
**** 17:38:25 UTY2411 Processing start date: WED APR 24, 2019
     ========================================================================
     =                                                                      =
     =          Logon/Connection                                            =
     =                                                                      =
     ========================================================================
0001 .DEBUG TRACE LOAD;
0002 .LOGTABLE TESTPSALOGS;

0003 .LOGON NODEID/FLUSER,;
**** 17:38:30 UTY8400 Teradata Database Release: 17.00.00.00
**** 17:38:30 UTY8400 Teradata Database Version: 17.00.00.00
**** 17:38:30 UTY8400 Default character set: ASCII
**** 17:38:30 UTY8400 Current RDBMS has UDT support
**** 17:38:30 UTY8400 Current RDBMS has Large Decimal support
**** 17:38:30 UTY8400 Current RDBMS has Statement Info Parcel support
**** 17:38:30 UTY8400 Maximum supported buffer size: 1M
**** 17:38:30 UTY8400 Upsert supported by RDBMS server
**** 17:38:30 UTY8400 Data Encryption supported by RDBMS server
**** 17:38:30 UTY8400 Array Support supported by RDBMS server
**** 17:38:30 UTY8400 Statement Independence supported by RDBMS server
**** 17:38:32 UTY6211 A successful connect was made to the RDBMS.
**** 17:38:32 UTY6217 Logtable 'FLUSER.TESTPSALOGS' has been created.
     ========================================================================
     =                                                                      =
     =          Processing Control Statements                               =
     =                                                                      =
     ========================================================================

0004 delete from TESTSA01;
**** 17:38:33 UTY1016 'DELETE' request successful.

0005 .SET WEDDT TO '2019-05-02';

0006 .DISPLAY '&WEDDT' TO FILE *;
**** 17:38:33 UTY2402 Previous statement modified to:
0007 .DISPLAY '2019-05-02' TO FILE *;
     2019-05-02

0008 .DISPLAY '2019-05-02' TO FILE *;
     2019-05-02

0009 .BEGIN
     CHECKPOINT 15
     SESSIONS 4 1
     TENACITY 2
     ERRORTABLE TPERRTESTSA01
     ROBUST OFF;
     ========================================================================
     =                                                                      =
     =          Processing TPump Statements                                 =
     =                                                                      =
     ========================================================================

0010 .LAYOUT LAY0012;
0011 .FIELD FF1 * INTEGER KEY;
0012 .FIELD FF2 * CHAR(10);
0013 .FIELD FF3 * CHAR(10);

0014 .DML LABEL LABEL0012;
0015 INSERT INTO TESTSA01 VALUES ( :FF1, :FF2, :FF3 );

0016 .IMPORT INFILE FEXPDATA
     LAYOUT LAY0012
     APPLY LABEL0012;

0017 .END LOAD;
**** 17:38:33 UTY6609 Starting to log on sessions...
     StartConn: connect DBCHCL status: 0
     StartConn: connect DBCHCL status: 0
     StartConn: connect DBCHCL status: 0
     StartConn: connect DBCHCL status: 0
     WaitForResponse: Calling dbchwat
     WaitForResponse: Returned from dbchwat
     DBCAreaPtr->fet_parcel_flavor is 8
     DBCAreaPtr->fet_parcel_flavor is 12
     Logged on session[0] 16 TDPSess = 274323
     WaitForResponse: Calling dbchwat
     WaitForResponse: Returned from dbchwat
     DBCAreaPtr->fet_parcel_flavor is 8
     DBCAreaPtr->fet_parcel_flavor is 12
     Logged on session[1] 17 TDPSess = 274324
     WaitForResponse: Calling dbchwat
     WaitForResponse: Returned from dbchwat
     DBCAreaPtr->fet_parcel_flavor is 8
     DBCAreaPtr->fet_parcel_flavor is 12
     Logged on session[2] 18 TDPSess = 274325
     WaitForResponse: Calling dbchwat
     WaitForResponse: Returned from dbchwat
     DBCAreaPtr->fet_parcel_flavor is 8
     DBCAreaPtr->fet_parcel_flavor is 12
     Logged on session[3] 19 TDPSess = 274326
**** 17:38:37 UTY6610 Logged on 4 sessions.
     ========================================================================
     =                                                                      =
     =          TPump Import(s) Beginning                                   =
     =                                                                      =
     ========================================================================
**** 17:38:37 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.
     StmtGenTest buffer len: 96
     StmtGenTest request len: 95
     Preparing SQL: 'USING(FF1 INTEGER,FF2 CHAR(10),FF3 CHAR(10)) INSERT INTO
     TESTSA01 VALUES ( :FF1, :FF2, :FF3 );
     '
     StmtGenMacro buffer len: 1520
     StmtGenMacro request len: 186
     macro: CREATE MACRO FLUSER.M20190502_173839_76635_001_001(FF1 INTEGER,FF2
     CHAR(10) CHARACTER SET LATIN,FF3 CHAR(10) CHARACTER SET LATIN) AS (INSERT
     INTO TESTSA01 VALUES ( :FF1, :FF2, :FF3 );
     );
     Testing pack factor 20
     StmtGenTemplate nOneStmtUBytes: 38
     StmtGenTemplate nUsingBytes: 767
     StmtGenTemplate nStmtBytes: 59
     StmtGenTemplate buffer len: 1954
     StmtGenTemplate request len: 1953
     Sqllen: 1953, Datalen: 480, Maxlen: 1048472
     TESTPACKFACTOR: extra_cli_overhead: 0
     Partition DEFAULT PARTITION using request template
     token = 0, i_sess_id = Ctx->Id = 16
     Sending 57 byte request: 'exec TPumpMacro.ImportCreate('FLUSER',
     'TESTPSALOGS', 1);'
     Using 0 byte(s) of data: ''
     Ctx->ReqId updated to o_req_id = 2
     DBCAreaPtr->fet_parcel_flavor is 9
**** 17:38:41 UTY8802 WARNING: Rate Monitoring turned off - database TPumpMacro
     does not exist.
**** 17:38:41 UTY6608 Import 1 begins.
     DEFAULT PARTITION session 0 Buckets: 1 Total Buckets: 1
     Hit End of file
     calling SessCheckT w/ timeout = 60
     Flushing backlog
     Sending Bucket on DEFAULT PARTITION session 0
     token = 0, i_sess_id = Ctx->Id = 16
     Sending 498 byte request: 'USING(AA1 INTEGER,AA2 CHAR(10),AA3 CHAR(10),AB1
     INTEGER,AB2 CHAR(10),AB3 CHAR(10),AC1 INTEGER,AC2 CHAR(10),AC3 CHAR(10),AD1
     INTEGER,AD2 CHAR(10),AD3 CHAR(10),AE1 INTEGER,AE2 CHAR(10),AE3 CHAR(10))
     BT;EXEC FLUSER.M20190502_173839_76635_001_001(:AA1,:AA2,:AA3);EXEC
     FLUSER.M20190502_173839_76635_001_001(:AB1,:AB2,:AB3);EXEC
     FLUSER.M20190502_173839_76635_001_001(:AC1,:AC2,:AC3);EXEC
     FLUSER.M20190502_173839_76635_001_001(:AD1,:AD2,:AD3);EXEC
     FLUSER.M20190502_173839_76635_001_001(:AE1,:AE2,:AE3);ET;'
     Using 120 byte(s) of data:
     '01000000412020202020202020204141202020202020202002000000422020202020202020
     204141202020202020202003000000432020202020202020204141202020202020202004000
     000442020202020202020204141202020202020202005000000452020202020202020204141
     2020202020202020'
     Ctx->ReqId updated to o_req_id = 3
     calling SessCheckT w/ timeout = 60
     WaitForResponse: Calling dbchwat
     WaitForResponse: Returned from dbchwat
     WaitForResponse returned token 0
     Corresponding session has status = 1, Ctx->Id = 16, Ctx->ReqId = 3
     DBCAreaPtr->fet_parcel_flavor is 205
     DBCAreaPtr->fet_parcel_flavor is 11
     DBCAreaPtr->fet_parcel_flavor is 205
     DBCAreaPtr->fet_parcel_flavor is 11
     DBCAreaPtr->fet_parcel_flavor is 205
     DBCAreaPtr->fet_parcel_flavor is 11
     DBCAreaPtr->fet_parcel_flavor is 205
     DBCAreaPtr->fet_parcel_flavor is 11
     DBCAreaPtr->fet_parcel_flavor is 205
     DBCAreaPtr->fet_parcel_flavor is 11
     DBCAreaPtr->fet_parcel_flavor is 205
     DBCAreaPtr->fet_parcel_flavor is 11
     DBCAreaPtr->fet_parcel_flavor is 205
     DBCAreaPtr->fet_parcel_flavor is 11
     DBCAreaPtr->fet_parcel_flavor is 12
     done on DEFAULT PARTITION session 0
     Flushing backlog
**** 17:38:42 UTY6641 Since last chkpt., 5 recs. in, 5 stmts., 1 reqs
**** 17:38:42 UTY6647 Since last chkpt., avg. DBS wait time: 546.00
**** 17:38:42 UTY6612 Beginning final checkpoint...
**** 17:38:42 UTY6641 Since last chkpt., 5 recs. in, 5 stmts., 1 reqs
**** 17:38:42 UTY6647 Since last chkpt., avg. DBS wait time: 546.00
**** 17:38:42 UTY6607 Checkpoint Completes with 5 rows sent.
**** 17:38:42 UTY6642 Import 1 statements: 5, requests: 1
**** 17:38:42 UTY6643 Import 1 average statements per request: 5.00
**** 17:38:42 UTY6644 Import 1 average statements per record: 1.00
**** 17:38:42 UTY6645 Import 1 statements/session: avg. 1.25, min. 0.00, max.
     5.00
**** 17:38:42 UTY6646 Import 1 requests/session: average 0.25, minimum 0.00,
     maximum 1.00
**** 17:38:42 UTY6648 Import 1 DBS wait time/session: avg. 136.50, min. 0.00,
     max. 546.00
**** 17:38:42 UTY6649 Import 1 DBS wait time/request: avg. 136.50, min. 0.00,
     max. 546.00
**** 17:38:42 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
**** 17:38:42 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
**** 17:38:44 UTY0821 Error table FLUSER.TPERRTESTSA01 is EMPTY, dropping
     table.
     token = 0, i_sess_id = Ctx->Id = 16
     Sending 57 byte request: 'exec TPumpMacro.DeleteImport('FLUSER',
     'TESTPSALOGS', 1);'
     Using 0 byte(s) of data: ''
     Ctx->ReqId updated to o_req_id = 4
     DBCAreaPtr->fet_parcel_flavor is 9


     ========================================================================
     =                                                                      =
     =          Logoff/Disconnect                                           =
     =                                                                      =
     ========================================================================
**** 17:38:46 UTY6216 The restart log table has been dropped.
**** 17:38:46 UTY6212 A successful disconnect was made from the RDBMS.
**** 17:38:46 UTY2410 Total processor time used = '0.405603 Seconds'
     .       Start : 17:38:24 - WED APR 24, 2019
     .       End   : 17:38:46 - WED APR 24, 2019
     .       Highest return code encountered = '0'.
     getting out w/rc 0