======================================================================== = = = MultiLoad Utility Release MLOD.16.10.00.00 = = Platform LINUX = = PID 18924 = = = ======================================================================== = = = Copyright 1990-2017 Teradata Corporation. ALL RIGHTS RESERVED. = = = ======================================================================== **** 18:05:55 UTY2411 Processing start date: WED JUN 07, 2023 ======================================================================== = = = Logon/Connection = = = ======================================================================== 0001 .LOGTABLE custload_log; 0002 .LOGON 127.0.0.1/test,; **** 18:05:55 UTY8400 Teradata Database Release: 16.10.00.03 **** 18:05:55 UTY8400 Teradata Database Version: 16.10.00.03 **** 18:05:55 UTY8400 Default character set: ASCII **** 18:05:55 UTY8400 Current RDBMS has interval support **** 18:05:55 UTY8400 Current RDBMS has UDT support **** 18:05:55 UTY8400 Current RDBMS has Large Decimal support **** 18:05:55 UTY8400 Current RDBMS has TASM support **** 18:05:55 UTY8400 Maximum supported buffer size: 1M **** 18:05:55 UTY8400 Data Encryption supported by RDBMS server **** 18:05:55 UTY6211 A successful connect was made to the RDBMS. **** 18:05:55 UTY6217 Logtable 'TEST.custload_log' has been created. ======================================================================== = = = Processing Control Statements = = = ======================================================================== 0003 .BEGIN MLOAD TABLES Richcustomer,poorcustomer; ======================================================================== = = = Processing MultiLoad Statements = = = ======================================================================== 0004 .LAYOUT custrec ; 0005 .FIELD fcid * VARCHAR(100); 0006 .FIELD fcname * VARCHAR(100); 0007 .FIELD fdob * VARCHAR(100); 0008 .FIELD fcatg * VARCHAR(100); 0009 .DML LABEL insRichCustomer; 0010 INSERT INTO Richcustomer (cid,cname,dob) VALUES (:fcid,:fcname,:fdob (FORMAT 'YYYY-MMM-DD')); 0011 .DML LABEL insPoorCustomer; 0012 INSERT INTO poorcustomer (cid,cname,dob) VALUES (:fcid,:fcname,:fdob (FORMAT 'YYYY-MMM-DD')); 0013 .IMPORT INFILE /root/training/customer.csv LAYOUT custrec FORMAT VARTEXT ',' FROM 2 APPLY insRichCustomer WHERE fcatg ='R' APPLY insPoorCustomer WHERE fcatg ='P' ; 0014 .END MLOAD ; ======================================================================== = = = MultiLoad Initial Phase = = = ======================================================================== **** 18:05:55 UTY0829 Options in effect for this MultiLoad import task: . Sessions: One session per available amp. . Checkpoint: 15 minute(s). . Tenacity: 4 hour limit to successfully connect load sessions. . Errlimit: No limit in effect. . AmpCheck: In effect for apply phase transitions. **** 18:05:55 UTY0817 MultiLoad submitting the following request: Select NULL from TEST.custload_log where (LogType = 125) and (Seq = 1) and (MloadSeq = 0); **** 18:05:55 UTY0817 MultiLoad submitting the following request: Select NULL from TEST.custload_log where (LogType = 120) and (Seq = 1); **** 18:05:55 UTY0817 MultiLoad submitting the following request: SET QUERY_BAND='UTILITYNAME=MULTLOAD;' UPDATE FOR SESSION; **** 18:05:55 UTY0817 MultiLoad submitting the following request: CHECK WORKLOAD FOR BEGIN MLOAD Richcustomer,poorcustomer; **** 18:05:55 UTY0817 MultiLoad submitting the following request: CHECK WORKLOAD END; **** 18:05:55 UTY0844 Session count 2 returned by the DBS overrides user-requested session count. **** 18:05:55 UTY0815 MLOAD session(s) connected: 2. **** 18:05:55 UTY0817 MultiLoad submitting the following request: BEGIN MLOAD Richcustomer,poorcustomer WITH INTERVAL; **** 18:05:55 UTY0817 MultiLoad submitting the following request: INS TEST.custload_log (LogType, Seq, MLoadSeq)VALUES(130, 1, 10); **** 18:05:55 UTY0817 MultiLoad submitting the following request: MLOAD Richcustomer with WT_Richcustomer errortables ET_Richcustomer, UV_Richcustomer; **** 18:06:01 UTY0817 MultiLoad submitting the following request: MLOAD poorcustomer with WT_poorcustomer errortables ET_poorcustomer, UV_poorcustomer; ======================================================================== = = = MultiLoad DML Transaction Phase = = = ======================================================================== **** 18:06:01 UTY0817 MultiLoad submitting the following request: BT; **** 18:06:01 UTY0817 MultiLoad submitting the following request: USING FCID(VARCHAR(100)), FCNAME(VARCHAR(100)), FDOB(VARCHAR(100)), FCATG(VARCHAR(100)) INSERT INTO Richcustomer (cid,cname,dob) VALUES (:fcid,:fcname,:fdob (FORMAT 'YYYY-MMM-DD')); **** 18:06:01 UTY0817 MultiLoad submitting the following request: USING FCID(VARCHAR(100)), FCNAME(VARCHAR(100)), FDOB(VARCHAR(100)), FCATG(VARCHAR(100)) INSERT INTO poorcustomer (cid,cname,dob) VALUES (:fcid,:fcname,:fdob (FORMAT 'YYYY-MMM-DD')); **** 18:06:01 UTY0817 MultiLoad submitting the following request: INS TEST.custload_log (LogType, Seq, MLoadSeq)VALUES(130, 1, 20); **** 18:06:01 UTY0817 MultiLoad submitting the following request: ET; ======================================================================== = = = MultiLoad Acquisition Phase = = = ======================================================================== **** 18:06:01 UTY0817 MultiLoad submitting the following request: BEGIN TRANSACTION; **** 18:06:01 UTY0817 MultiLoad submitting the following request: CHECKPOINT LOADING INTERVAL 0; **** 18:06:01 UTY0817 MultiLoad submitting the following request: CHECKPOINT LOADING INTERVAL 0; **** 18:06:02 UTY0817 MultiLoad submitting the following request: CHECKPOINT LOADING INTERVAL 0; **** 18:06:03 UTY0817 MultiLoad submitting the following request: USING Ckpt(VARBYTE(1024)) INSERT TEST.custload_log (Logtype, Seq, MLoadSeq, MLoadImpSeq, MLoadSrcSeq, MiscInt1,MiscInt2,MiscInt3,MiscInt4, MiscInt5,MiscInt6,MiscInt7,MiscInt8,CkptInterval,byteflag,MLoadCkpt) VALUES (110, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, :Ckpt); **** 18:06:03 UTY0817 MultiLoad submitting the following request: CHECKPOINT LOADING INTERVAL 0; **** 18:06:04 UTY0817 MultiLoad submitting the following request: USING Ckpt(VARBYTE(1024)) INSERT TEST.custload_log (Logtype, Seq, MLoadSeq, MLoadImpSeq, MLoadSrcSeq, MiscInt1,MiscInt2,MiscInt3,MiscInt4, MiscInt5,MiscInt6,MiscInt7,MiscInt8,CkptInterval,byteflag,MLoadCkpt) VALUES (110, 1, 1, 1, 0, 7, 7, 7, 7, 0, 0, 0, 0, 0, 1, :Ckpt); **** 18:06:04 UTY0826 A checkpoint has been taken, recording that end of file has been reached for IMPORT 1 of this MultiLoad Import task. **** 18:06:04 UTY0817 MultiLoad submitting the following request: CHECKPOINT LOADING INTERVAL 1; **** 18:06:05 UTY0817 MultiLoad submitting the following request: USING Ckpt(VARBYTE(1024)) INSERT TEST.custload_log (Logtype, Seq, MLoadSeq, MLoadImpSeq, MLoadSrcSeq, MiscInt1,MiscInt2,MiscInt3,MiscInt4, MiscInt5,MiscInt6,MiscInt7,MiscInt8,CkptInterval,byteflag,MLoadCkpt) VALUES (110, 1, 2, 1, 0, 7, 7, 7, 7, 0, 0, 0, 0, 1, 1, :Ckpt); **** 18:06:05 UTY1803 Import processing statistics . IMPORT 1 Total thus far . ========= ============== Candidate records considered:........ 7....... 7 Apply conditions satisfied:.......... 7....... 7 Candidate records not applied:....... 0....... 0 Candidate records rejected:.......... 0....... 0 **** 18:06:05 UTY1821 Aquisition Phase statistics Elapsed time: 00:00:04 CPU time: 0 Seconds MB/sec: 5.1e-05 MB/cpusec: N/A **** 18:06:05 UTY0817 MultiLoad submitting the following request: CHECKPOINT LOADING INTERVAL 1; **** 18:06:06 UTY0817 MultiLoad submitting the following request: CHECKPOINT LOADING INTERVAL 1 END; **** 18:06:07 UTY0817 MultiLoad submitting the following request: INS TEST.custload_log (LogType, Seq, MLoadSeq)VALUES(130, 1, 30); **** 18:06:07 UTY0817 MultiLoad submitting the following request: ET; ======================================================================== = = = MultiLoad Application Phase = = = ======================================================================== **** 18:06:07 UTY0817 MultiLoad submitting the following request: EXEC MLOAD Richcustomer;EXEC MLOAD poorcustomer; **** 18:06:08 UTY0818 Statistics for table Richcustomer: Inserts: 0 Updates: 0 Deletes: 0 **** 18:06:08 UTY0818 Statistics for table poorcustomer: Inserts: 0 Updates: 0 Deletes: 0 **** 18:06:08 UTY1822 Application Phase statistics Elapsed time: 00:00:01 **** 18:06:08 UTY0817 MultiLoad submitting the following request: INS TEST.custload_log (LogType, Seq) VALUES (115, 1) **** 18:06:08 UTY0817 MultiLoad submitting the following request: BEGIN TRANSACTION; **** 18:06:08 UTY0817 MultiLoad submitting the following request: END MLOAD; **** 18:06:08 UTY0817 MultiLoad submitting the following request: INS TEST.custload_log (LogType, Seq) VALUES (120, 1) **** 18:06:08 UTY0817 MultiLoad submitting the following request: USING Ckpt(VARBYTE(1024)) INS TEST.custload_log (LogType, Seq, MLoadCkpt)VALUES(135, 1, :Ckpt); **** 18:06:09 UTY0817 MultiLoad submitting the following request: END TRANSACTION; ======================================================================== = = = MultiLoad Task Cleanup = = = ======================================================================== **** 18:06:09 UTY0817 MultiLoad submitting the following request: SELECT CAST(COUNT(*) AS BIGINT) FROM ET_Richcustomer; **** 18:06:09 UTY0821 Error table ET_Richcustomer is EMPTY, dropping table. **** 18:06:09 UTY0817 MultiLoad submitting the following request: BEGIN TRANSACTION; **** 18:06:09 UTY0817 MultiLoad submitting the following request: INS TEST.custload_log (LogType, Seq, MLoadSeq)VALUES(125, 1, 1) **** 18:06:09 UTY0817 MultiLoad submitting the following request: DROP TABLE ET_Richcustomer; **** 18:06:09 UTY0817 MultiLoad submitting the following request: END TRANSACTION; **** 18:06:09 UTY0817 MultiLoad submitting the following request: SELECT CAST(COUNT(*) AS BIGINT) FROM UV_Richcustomer; **** 18:06:09 UTY0846 Error table UV_Richcustomer contains 5 rows. **** 18:06:09 UTY0817 MultiLoad submitting the following request: BEGIN TRANSACTION; **** 18:06:09 UTY0817 MultiLoad submitting the following request: INS TEST.custload_log (LogType, Seq, MLoadSeq)VALUES(125, 1, 3) **** 18:06:09 UTY0817 MultiLoad submitting the following request: DROP TABLE WT_Richcustomer; **** 18:06:09 UTY0817 MultiLoad submitting the following request: END TRANSACTION; **** 18:06:09 UTY0817 MultiLoad submitting the following request: SELECT CAST(COUNT(*) AS BIGINT) FROM ET_poorcustomer; **** 18:06:09 UTY0846 Error table ET_poorcustomer contains 1 rows. **** 18:06:09 UTY0817 MultiLoad submitting the following request: SELECT CAST(COUNT(*) AS BIGINT) FROM UV_poorcustomer; **** 18:06:09 UTY0846 Error table UV_poorcustomer contains 1 rows. **** 18:06:09 UTY0817 MultiLoad submitting the following request: BEGIN TRANSACTION; **** 18:06:09 UTY0817 MultiLoad submitting the following request: INS TEST.custload_log (LogType, Seq, MLoadSeq)VALUES(125, 1, 6) **** 18:06:09 UTY0817 MultiLoad submitting the following request: DROP TABLE WT_poorcustomer; **** 18:06:09 UTY0817 MultiLoad submitting the following request: END TRANSACTION; **** 18:06:09 UTY0825 Error table statistics for: Target table 1: Richcustomer Number of Rows Error Table Name ==================== ================================================== 0 ET_Richcustomer 5 UV_Richcustomer Target table 2: poorcustomer Number of Rows Error Table Name ==================== ================================================== 1 ET_poorcustomer 1 UV_poorcustomer **** 18:06:09 UTY0817 MultiLoad submitting the following request: BEGIN TRANSACTION; **** 18:06:09 UTY0817 MultiLoad submitting the following request: USING Ckpt(VARBYTE(1024)) INS TEST.custload_log (LogType, Seq, MLoadCkpt)VALUES(140, 1, :Ckpt); **** 18:06:09 UTY0817 MultiLoad submitting the following request: INS TEST.custload_log (LogType, Seq) VALUES (125, 1) **** 18:06:09 UTY0817 MultiLoad submitting the following request: END TRANSACTION; **** 18:06:09 UTY0822 MultiLoad processing complete for this MultiLoad import task. ======================================================================== = = = MultiLoad Task Complete = = = ======================================================================== **** 18:06:09 UTY1024 Session modal request, 'SET QUERY_BAND='UTILITYNAME=MULTLOAD;' UPDATE FOR SESSION;', re-executed. ======================================================================== = = = Processing Control Statements = = = ======================================================================== 0015 .LOGOFF; ======================================================================== = = = Logoff/Disconnect = = = ======================================================================== **** 18:06:10 UTY6216 The restart log table has been dropped. **** 18:06:10 UTY6212 A successful disconnect was made from the RDBMS. **** 18:06:10 UTY2410 Total processor time used = '0.2 Seconds' . Start : 18:05:55 - WED JUN 07, 2023 . End : 18:06:10 - WED JUN 07, 2023 . Highest return code encountered = '0'.