Sample Output - 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 is a sample output when ".DEBUG TRACE LOAD" is specified in TPump script:

     ========================================================================
     =                                                                      =
     =          Teradata Parallel Data Pump Utility    Release 16.20.00.00  =
     =          Platform WIN32                                              =
     =          PID      14028                                              =
     =                                                                      =
     ========================================================================
     =                                                                      =
     =     Copyright 1997-2017 Teradata Corporation. ALL RIGHTS RESERVED.   =
     =                                                                      =
     ========================================================================
**** 15:51:39 UTY2411 Processing start date: THU SEP 21, 2017
     ========================================================================
     =                                                                      =
     =          Logon/Connection                                            =
     =                                                                      =
     ========================================================================
0001 .DEBUG TRACE LOAD;
0002 .LOGTABLE TPLOG0623;
0003 .LOGON NODEID/fluser,;
**** 15:51:40 UTY8400 Teradata Database Release: 16.20.00.00
**** 15:51:40 UTY8400 Teradata Database Version: 16.20.00.00
**** 15:51:40 UTY8400 Default character set: ASCII
**** 15:51:40 UTY8400 Current RDBMS has UDT support
**** 15:51:40 UTY8400 Current RDBMS has Large Decimal support
**** 15:51:40 UTY8400 Current RDBMS has Statement Info Parcel support
**** 15:51:40 UTY8400 Maximum supported buffer size: 1M
**** 15:51:40 UTY8400 Upsert supported by RDBMS server
**** 15:51:40 UTY8400 Data Encryption supported by RDBMS server
**** 15:51:40 UTY8400 Array Support supported by RDBMS server
**** 15:51:40 UTY8400 Statement Independence supported by RDBMS server
**** 15:51:42 UTY6211 A successful connect was made to the RDBMS.
**** 15:51:42 UTY6217 Logtable 'FLUSER.TPLOG0623' has been created.
     ========================================================================
     =                                                                      =
     =          Processing Control Statements                               =
     =                                                                      =
     ========================================================================

0004 DROP TABLE TPTBL0623;
**** 15:51:43 UTY1016 'DROP' request successful.
0005 DROP TABLE TPERR0623;
**** 15:51:44 UTY1008 RDBMS failure: 3807, Object 'TPERR0623' does not exist.
0006
     CREATE TABLE TPTBL0623, FALLBACK(
        F1 INTEGER,     F2 CHAR(50),
        F3 VARCHAR(50), F4 FLOAT,
        F5 BYTE (10),   F6 VARBYTE (10),
        F7 DECIMAL(8,2),F8 BYTEINT,
        F9 SMALLINT,    F10 DATE)
     UNIQUE PRIMARY INDEX (F1);
**** 15:51:45 UTY1016 'CREATE' request successful.

0007 .BEGIN LOAD CHECKPOINT 15 SESSIONS 4 1
                 TENACITY 2 ERRORTABLE TPERR0623
                 ERRLIMIT 10 ROBUST OFF
                 PACK 500 DATAENCRYPTION ON
                 ARRAYSUPPORT ON RATE 200
                 RETRYTIMES 200 SLEEP 40
                 NOATOMICUPSERT MACRODB FLUSER
                 NOTIFY OFF SERIALIZE ON;
     ========================================================================
     =                                                                      =
     =          Processing TPump Statements                                 =
     =                                                                      =
     ========================================================================

0008 .LAYOUT LAY0623;
0009 .FIELD FF1 * INTEGER KEY;
0010 .FIELD FF2 * CHAR(50);
0011 .FIELD FF3 * VARCHAR(50);
0012 .FIELD FF4 * FLOAT;
0013 .FIELD FF5 * BYTE(10);
0014 .FIELD FF6 * VARBYTE(10);
0015 .FIELD FF7 * DECIMAL(8,2);
0016 .FIELD FF8 * BYTEINT;
0017 .FIELD FF9 * SMALLINT;
0018 .FIELD FF10 * DATE;

0019 .DML LABEL LABEL0623 IGNORE DUPLICATE ROWS;

0020  INSERT INTO TPTBL0623 VALUES (    :FF1,   :FF2,
                                :FF3,   :FF4,
                                :FF5,   :FF6,
                                :FF7,   :FF8,
                                :FF9,   :FF10);
0021 .IMPORT INFILE ALLTYPE
                    LAYOUT LAY0623
                    APPLY LABEL0623;
0022 .END LOAD;
**** 15:51:45 UTY6609 Starting to log on sessions...
     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 = 43724
     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 = 43725
     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 = 43726
**** 15:51:48 UTY6610 Logged on 3 sessions.
     ========================================================================
     =                                                                      =
     =          TPump Import(s) Beginning                                   =
     =                                                                      =
     ========================================================================
**** 15:51:48 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:    10 rejected record(s).
     .   Restart Mode:    SIMPLE.
     .  Serialization:    ON.
     .        Packing:    500 Statements per Request.
     .   StartUp Rate:    200 Statements per Minute.
     .Rate Per Period:    50 Statements per 15000 milliseconds.
     .  Atomic Upsert:    DISABLED.
     StmtGenTest buffer len: 250
     StmtGenTest request len: 249
     Preparing SQL: 'USING(FF1 INTEGER,FF2 CHAR(50),FF3 VARCHAR(50),FF4
     FLOAT,FF5 BYTE(10),FF6 VARBYTE(10),FF7 DECIMAL(8,2),FF8 BYTEINT,FF9
     SMALLINT,FF10 DATE)  INSERT INTO TPTBL0623 VALUES (        :FF1,   :FF2,
                                :FF3,   :FF4,
                                :FF5,   :FF6,
                                :FF7,   :FF8,
                                :FF9,   :FF10);
     '
     StmtGenMacro buffer len: 1849
     StmtGenMacro request len: 340
     macro: CREATE MACRO FLUSER.M20170921_155150_94481_001_001(FF1 INTEGER,FF2
     CHAR(50) CHARACTER SET LATIN,FF3 VARCHAR(50) CHARACTER SET LATIN,FF4
     FLOAT,FF5 BYTE(10),FF6 VARBYTE(10),FF7 DECIMAL(8,2),FF8 BYTEINT,FF9
     SMALLINT,FF10 DATE) AS ( INSERT INTO TPTBL0623 VALUES (    :FF1,   :FF2,
                                :FF3,   :FF4,
                                :FF5,   :FF6,
                                :FF7,   :FF8,
                                :FF9,   :FF10);
     );
     Testing pack factor 500
     StmtGenTemplate nOneStmtUBytes: 132
     StmtGenTemplate nUsingBytes: 139
     StmtGenTemplate nStmtBytes: 95
     StmtGenTemplate buffer len: 235
     StmtGenTemplate request len: 234
     Sqllen: 234, Datalen: 73500, Maxlen: 1048472
     TESTPACKFACTOR: extra_cli_overhead: 4000
     Partition DEFAULT PARTITION using request template
     token = 0, i_sess_id = Ctx->Id = 16
     Sending 55 byte request: 'exec TPumpMacro.ImportCreate('FLUSER',
     'TPLOG0623', 1);'
     Using 0 byte(s) of data: ''
     Ctx->ReqId updated to o_req_id = 2
     DBCAreaPtr->fet_parcel_flavor is 9
**** 15:51:52 UTY8802 WARNING: Rate Monitoring turned off - database TPumpMacro
     does not exist.
**** 15:51:52 UTY6608 Import 1 begins.
     DEFAULT PARTITION session 1 Buckets: 1 Total Buckets: 1
     DEFAULT PARTITION session 2 Buckets: 1 Total Buckets: 2
     DEFAULT PARTITION session 0 Buckets: 1 Total Buckets: 3
     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 3 byte request: 'BT;'
     Using 0 byte(s) of data: ''
     Ctx->ReqId updated to o_req_id = 3
     Sending Bucket on DEFAULT PARTITION session 1
     token = 1, i_sess_id = Ctx->Id = 17
     Sending 3 byte request: 'BT;'
     Using 0 byte(s) of data: ''
     Ctx->ReqId updated to o_req_id = 2
     Sending Bucket on DEFAULT PARTITION session 2
     token = 2, i_sess_id = Ctx->Id = 18
     Sending 3 byte request: 'BT;'
     Using 0 byte(s) of data: ''
     Ctx->ReqId updated to o_req_id = 2
     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 12
     token = 0, i_sess_id = Ctx->Id = 16
     Sending 234 byte request: 'USING(AA1 INTEGER,AA2 CHAR(50),AA3
     VARCHAR(50),AA4 FLOAT,AA5 BYTE(10),AA6 VARBYTE(10),AA7 DECIMAL(8,2),AA8
     BYTEINT,AA9 SMALLINT,AA10 DATE) EXEC
     FLUSER.M20170921_155150_94481_001_001(:AA1,:AA2,:AA3,:AA4,:AA5,:AA6,:AA7,:A
     A8,:AA9,:AA10);'
     using_data_count = 6, data starting address=01196c58
     Using data record # 0, len = 97, address = 03db3f80
     Using data:
     '03000000424242202020202020202020202020202020202020202020202020202020202020
     2020202020202020202020202020202020080042424242424242420000000000000000C0000
     0000000000000000200C0C1FC4E00000D670077270000'
     Using data record # 1, len = 97, address = 03db3fe1
     Using data:
     '06000000454545202020202020202020202020202020202020202020202020202020202020
     2020202020202020202020202020202020080045454545454545450000000000405A40F0000
     0000000000000000200F0F128500000106A007A270000'
     Using data record # 2, len = 93, address = 03db4042
     Using data:
     '09000000484848202020202020202020202020202020202020202020202020202020202020
     20202020202020202020202020202020200400484848480000000000005B40A300000000000
     00000000200A3A400000000136D007D270000'
     Using data record # 3, len = 94, address = 03db409f
     Using data:
     '0C0000004B4B4B202020202020202020202020202020202020202020202020202020202020
     202020202020202020202020202020202005004B4B4B4B4B0000000000C05B40B3000000000
     0000000000200B3B46C52000016700080270000'
     Using data record # 4, len = 96, address = 03db40fd
     Using data:
     '0F0000004E4E4E202020202020202020202020202020202020202020202020202020202020
     202020202020202020202020202020202007004E4E4E4E4E4E4E0000000000805C40C300000
     00000000000000200C3C4AC53000019730083270000'
     Using data record # 5, len = 95, address = 03db415d
     Using data:
     '12000000515151202020202020202020202020202020202020202020202020202020202020
     202020202020202020202020202020202006005151515151510000000000405D40FF0000000
     000000000000200D2D3745400001B760086270000'
     Ctx->ReqId updated to o_req_id = 4
     Flushing backlog
     calling SessCheckT w/ timeout = 59
     WaitForResponse: Calling dbchwat
     WaitForResponse: Returned from dbchwat
     WaitForResponse returned token 1
     Corresponding session has status = 1, Ctx->Id = 17, Ctx->ReqId = 2
     DBCAreaPtr->fet_parcel_flavor is 205
     DBCAreaPtr->fet_parcel_flavor is 11
     DBCAreaPtr->fet_parcel_flavor is 12
     token = 1, i_sess_id = Ctx->Id = 17
     Sending 234 byte request: 'USING(AA1 INTEGER,AA2 CHAR(50),AA3
     VARCHAR(50),AA4 FLOAT,AA5 BYTE(10),AA6 VARBYTE(10),AA7 DECIMAL(8,2),AA8
     BYTEINT,AA9 SMALLINT,AA10 DATE) EXEC
     FLUSER.M20170921_155150_94481_001_001(:AA1,:AA2,:AA3,:AA4,:AA5,:AA6,:AA7,:A
     A8,:AA9,:AA10);'
     using_data_count = 7, data starting address=01140968
     Using data record # 0, len = 97, address = 03d90050
     Using data:
     '010000004E4352202020202020202020202020202020202020202020202020202020202020
     2020202020202020202020202020202020080054455241444154410000000000005940A0000
     0000000000000000200A0A1344E00000B640075270000'
     Using data record # 1, len = 95, address = 03d900b1
     Using data:
     '04000000434343202020202020202020202020202020202020202020202020202020202020
     202020202020202020202020202020202006004343434343430000000000C05940D00000000
     000000000000200D0D1604F00000E680078270000'
     Using data record # 2, len = 96, address = 03d90110
     Using data:
     '07000000464646202020202020202020202020202020202020202020202020202020202020
     20202020202020202020202020202020200700464646464646460000000000805A40A100000
     00000000000000200A1A29F8601001100007B270000'
     Using data record # 3, len = 87, address = 03d90170
     Using data:
     '0A000000202020202020202020202020202020202020202020202020202020202020202020
     202020202020202020202020202020202000000000000000000000000000000000000000000
     0000000000000000000000000'
     Using data record # 4, len = 95, address = 03d901c7
     Using data:
     '0D0000004C4C4C202020202020202020202020202020202020202020202020202020202020
     202020202020202020202020202020202006004C4C4C4C4C4C0000000000005C40C10000000
     000000000000200C1C2E452000017710081270000'
     Using data record # 5, len = 96, address = 03d90226
     Using data:
     '100000004F4F4F202020202020202020202020202020202020202020202020202020202020
     202020202020202020202020202020202007004F4F4F4F4F4F4F0000000000C05C400000000
     00000000000000200D1D2105400001A740084270000'
     Using data record # 6, len = 95, address = 03d90286
     Using data:
     '13000000525252202020202020202020202020202020202020202020202020202020202020
     202020202020202020202020202020202006005151515151510000000000805D40F10000000
     000000000000200D2D3745400001B770087270000'
     Ctx->ReqId updated to o_req_id = 3
     Flushing backlog
     calling SessCheckT w/ timeout = 59
     WaitForResponse: Calling dbchwat
     WaitForResponse: Returned from dbchwat
     WaitForResponse returned token 2
     Corresponding session has status = 1, Ctx->Id = 18, Ctx->ReqId = 2
     DBCAreaPtr->fet_parcel_flavor is 205
     DBCAreaPtr->fet_parcel_flavor is 11
     DBCAreaPtr->fet_parcel_flavor is 12
     token = 2, i_sess_id = Ctx->Id = 18
     Sending 234 byte request: 'USING(AA1 INTEGER,AA2 CHAR(50),AA3
     VARCHAR(50),AA4 FLOAT,AA5 BYTE(10),AA6 VARBYTE(10),AA7 DECIMAL(8,2),AA8
     BYTEINT,AA9 SMALLINT,AA10 DATE) EXEC
     FLUSER.M20170921_155150_94481_001_001(:AA1,:AA2,:AA3,:AA4,:AA5,:AA6,:AA7,:A
     A8,:AA9,:AA10);'
     using_data_count = 7, data starting address=01145f90
     Using data record # 0, len = 89, address = 03da1f78
     Using data:
     '02000000202020202020202020202020202020202020202020202020202020202020202020
     202020202020202020202020202020202000000000000000405940B00000000000000000000
     200B0B1984E00000C660076270000'
     Using data record # 1, len = 94, address = 03da1fd1
     Using data:
     '05000000444444202020202020202020202020202020202020202020202020202020202020
     2020202020202020202020202020202020050044444444449A99999999195A40E0000000000
     0000000000200E0E1C44F00000F7F0000000000'
     Using data record # 2, len = 94, address = 03da202f
     Using data:
     '08000000474747202020202020202020202020202020202020202020202020202020202020
     20202020202020202020202020202020200700474747474747470000000000C05A40A200000
     00000000000000000F0500000126C007C270000'
     Using data record # 3, len = 95, address = 03da208d
     Using data:
     '0B0000004A4A4A202020202020202020202020202020202020202020202020202020202020
     202020202020202020202020202020202006004A4A4A4A4A4A0000000000805B40B20000000
     000000000000200B2B31C520000156F007F270000'
     Using data record # 4, len = 97, address = 03da20ec
     Using data:
     '0E0000004D4D4D202020202020202020202020202020202020202020202020202020202020
     202020202020202020202020202020202008004D4D4D4D4D4D4D4D0000000000405C40C2000
     0000000000000000200C2C34853000018720082270000'
     Using data record # 5, len = 95, address = 03da214d
     Using data:
     '11000000505050202020202020202020202020202020202020202020202020202020202020
     202020202020202020202020202020202006005050505050500000000000005D40D10000000
     000000000000200D2D3605400001B750085270000'
     Using data record # 6, len = 95, address = 03da21ac
     Using data:
     '14000000535353202020202020202020202020202020202020202020202020202020202020
     2020202020202020202020202020202020060052525252525252B81E85EB3F8F401F0000000
     000000000000200D2D3745400001B780088270000'
     Ctx->ReqId updated to o_req_id = 3
     Flushing backlog
     calling SessCheckT w/ timeout = 59
     WaitForResponse: Calling dbchwat
     WaitForResponse: Returned from dbchwat
     WaitForResponse returned token 0
     Corresponding session has status = 1, Ctx->Id = 16, Ctx->ReqId = 4
     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
     sending ET on DEFAULT PARTITION session 0
     token = 0, i_sess_id = Ctx->Id = 16
     Sending 6 byte request: ' ; ET;'
     Using 0 byte(s) of data: ''
     Ctx->ReqId updated to o_req_id = 5
     Flushing backlog
     calling SessCheckT w/ timeout = 58
     WaitForResponse: Calling dbchwat
     WaitForResponse: Returned from dbchwat
     WaitForResponse returned token 1
     Corresponding session has status = 1, Ctx->Id = 17, 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
     sending ET on DEFAULT PARTITION session 1
     token = 1, i_sess_id = Ctx->Id = 17
     Sending 6 byte request: ' ; ET;'
     Using 0 byte(s) of data: ''
     Ctx->ReqId updated to o_req_id = 4
     Flushing backlog
     calling SessCheckT w/ timeout = 58
     WaitForResponse: Calling dbchwat
     WaitForResponse: Returned from dbchwat
     WaitForResponse returned token 2
     Corresponding session has status = 1, Ctx->Id = 18, 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
     sending ET on DEFAULT PARTITION session 2
     token = 2, i_sess_id = Ctx->Id = 18
     Sending 6 byte request: ' ; ET;'
     Using 0 byte(s) of data: ''
     Ctx->ReqId updated to o_req_id = 4
     Flushing backlog
     calling SessCheckT w/ timeout = 58
     WaitForResponse: Calling dbchwat
     WaitForResponse: Returned from dbchwat
     WaitForResponse returned token 0
     Corresponding session has status = 1, Ctx->Id = 16, Ctx->ReqId = 5
     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
     calling SessCheckT w/ timeout = 58
     WaitForResponse: Calling dbchwat
     WaitForResponse: Returned from dbchwat
     WaitForResponse returned token 1
     Corresponding session has status = 1, Ctx->Id = 17, Ctx->ReqId = 4
     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 1
     Flushing backlog
     calling SessCheckT w/ timeout = 58
     WaitForResponse: Calling dbchwat
     WaitForResponse: Returned from dbchwat
     WaitForResponse returned token 2
     Corresponding session has status = 1, Ctx->Id = 18, Ctx->ReqId = 4
     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 2
     Flushing backlog
**** 15:51:54 UTY6641 Since last chkpt., 20 recs. in, 20 stmts., 3 reqs
**** 15:51:54 UTY6647 Since last chkpt., avg. DBS wait time: 120.00
**** 15:51:54 UTY6612 Beginning final checkpoint...
**** 15:51:54 UTY6641 Since last chkpt., 20 recs. in, 20 stmts., 3 reqs
**** 15:51:54 UTY6647 Since last chkpt., avg. DBS wait time: 120.00
**** 15:51:54 UTY6607 Checkpoint Completes with 20 rows sent.
**** 15:51:54 UTY6642 Import 1 statements: 20, requests: 3
**** 15:51:54 UTY6643 Import 1 average statements per request: 6.67
**** 15:51:54 UTY6644 Import 1 average statements per record: 1.00
**** 15:51:54 UTY6645 Import 1 statements/session: avg. 6.67, min. 6.00, max.
     7.00
**** 15:51:54 UTY6646 Import 1 requests/session: average 1.00, minimum 1.00,
     maximum 1.00
**** 15:51:54 UTY6648 Import 1 DBS wait time/session: avg. 120.00, min. 48.00,
     max. 203.00
**** 15:51:54 UTY6649 Import 1 DBS wait time/request: avg. 120.00, min. 48.00,
     max. 203.00
**** 15:51:54 UTY1823 Import processing statistics
     .                                           IMPORT  1      Total thus far
     .                                           =========      ==============
     Candidate records considered:....                  20                  20
     Apply conditions satisfied:......                  20                  20
     Records logable to error table:..                   0                   0
     Candidate records rejected:......                   0                   0
**** Statistics for Apply Label : LABEL0623
     Type:                 I
     Database:             FLUSER
     Table or Macro Name:  TPTBL0623
     Activity:             20
**** 15:51:55 UTY6677 Loading phase statistics
              Elapsed time:   00:00:00:03(dd:hh:mm:ss)
              CPU time:       0.015625 Seconds
              MB/sec:         0.000630667
              MB/cpusec:      0.121088
**** 15:51:56 UTY0821 Error table FLUSER.TPERR0623 is EMPTY, dropping table.
     token = 0, i_sess_id = Ctx->Id = 16
     Sending 55 byte request: 'exec TPumpMacro.DeleteImport('FLUSER',
     'TPLOG0623', 1);'
     Using 0 byte(s) of data: ''
     Ctx->ReqId updated to o_req_id = 6
     DBCAreaPtr->fet_parcel_flavor is 9
0023 .LOGOFF;
     ========================================================================
     =                                                                      =
     =          Logoff/Disconnect                                           =
     =                                                                      =
     ========================================================================
**** 15:51:58 UTY6216 The restart log table has been dropped.
**** 15:51:58 UTY6212 A successful disconnect was made from the RDBMS.
**** 15:51:58 UTY2410 Total processor time used = '0.28125 Seconds'
     .       Start : 15:51:39 - THU SEP 21, 2017
     .       End   : 15:51:58 - THU SEP 21, 2017
     .       Highest return code encountered = '0'.
     getting out w/rc 0