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