MLOAD SCRIPT ========================================= mload <<-EOF .LOGTABLE ATMN_PRDSTG_TBLS.SALES_ONLINE_LOG; .LOGON ${LOGON_STRING}; DELETE FROM ATMN_PRDSTG_TBLS.SALES_ONLINE; DROP TABLE ATMN_PRDSTG_TBLS.SALES_ONLINE_ET; DROP TABLE ATMN_PRDSTG_TBLS.SALES_ONLINE_UV; .BEGIN IMPORT MLOAD TABLES ATMN_PRDSTG_TBLS.SALES_ONLINE WORKTABLES ATMN_PRDSTG_TBLS.SALES_ONLINE_WT ERRORTABLES ATMN_PRDSTG_TBLS.SALES_ONLINE_ET ATMN_PRDSTG_TBLS.SALES_ONLINE_UV SESSIONS 9; . LAYOUT FILEIN; .FIELD TRNAS_WER_WER * VARCHAR(1000); .FIELD TRNAS_SEGMENT * VARCHAR(100); .FIELD CONTACT_DATE * VARCHAR(10) ; .FIELD TRANS_STATUS * VARCHAR(20) ; .DML LABEL INSERTS; INSERT INTO ATMN_PRDSTG_TBLS.SALES_ONLINE ( TRNAS_WER_WER, TRNAS_SEGMENT, CONTACT_DATE , TRANS_STATUS ) VALUES ( :TRNAS_WER_WER, :TRNAS_SEGMENT, : CONTACT_DATE , :TRANS_STATUS ); . IMPORT INFILE ${INDIR}/${MLOADFILE) FORMAT VARTEXT '|' LAYOUT FILEIN APPLY INSERTS; . END MLOAD; .SET RC to 0; .IF &SYSETCNT > 0 THEN; .SET RC TO 4: ENDIF; .LOGOFF &RC; EOF MLOAD_ERR=$? #Checking status for job. if [[ $MLOAD_ERR = 0 ]] then return 0 else return 20 ============================================== ================================================ ================================================ MLOAD LOG FILE ================================================== Source file for today's process /PRD/MLOAD/DATA/Online_sales_20191212.dat ### Remove additional delimiter before merging files 12/12/19 09:38:32] /production/code/bin/ONLINESALES | main Prep file Successful Loading with /PRD/MLOAD/DATA/Online_sales_20191212.txt MLOADDIR= prod/code/mload ======================================================================= MultiLoad Utility Release MLOD. 15.10.01.08 = Platform SOLARIS/SPARC = PID 12073 = ======================================================================= Copyright 1990-2017 Teradata Corporation. ALL RIGHTS RESERVED. ======================================================================= 09:38:32 UTY2411 Processing start date: FRI DEC 12, 2019 ================================================================== Logon/Connection ========================================================================= 0001 .LOGTABLE ATMN_PRDSTG_TBLS.SALES_ONLINE_LOG; 0002 .LOGON tddp/LDMRDS, : **** 09:38:32 OTY8400 Teradata Database Release: 15.10.05.22 **** 09:38:32 UTY8400 Teradata Database Version: 15.10.05.29D2D **** 09:38:32 UTY8400 Default character set: ASCII **** 09:38:32 UTY8400 Current RDBMS has interval support **** 09:38:32 UTY8400 Current RDBMS has UDT support *** 09:38:32 UTY8400 Current RDBMS has Large Decimal support *** 09:38:32 UTY8400 Current RDBMS has TASM Decimal support ===================================================================== Processing Control Statements ======================================================================= 0003 DELETE FROM ATMN_PRDSTG_TBLS.SALES_ONLINE; **** 09:38:34 UTY1016 'DELETE' request successful 0004 DROP TABLE ATMN_PRDSTG_TBLS.SALES_ONLINE_ET; **** 09:38:35 UTY1008 RDBMS failure 3807 object ATMN_PRDSTG_TBLS.SALES_ONLINE_ET does not exist 0005 DROP TABLE ATMN_PRDSTG_TBLS.SALES_ONLINE_UV **** 09:38:35 UTY1008 RDBMS failure 3807 object ATMN_PRDSTG_TBLS.SALES_ONLINE_UV does not exist 0006 .BEGIN IMPORT MLOAD TABLES ATMN_PRDSTG_TBLS.SALES_ONLINE WORKTABLES ATMN_PRDSTG_TBLS.SALES_ONLINE_WT ERROR TABLES ATMN_PRDSTG_TBLS.SALES_ONLINE_ET ATMN_PRDSTG_TBLS.SALES_ONLINE_UV SESSION 9; =========================================================== processing multiload statements ===================================================================== 0007 .LAYOUT LABEL INSERTS; 0008 .FIELD TRNAS_WER_WER * VARCHAR(1000) ; 0009 .FIELD TRNAS_SEGMENT * VARCHAR(100) ; 0010 .FIELD CONTACT_DATE * VARCHAR(10) ; 0011 .FIELD TRANS_STATUS * VARCHAR(20) ; 0012 .DML LABEL INSERTS; 0013 INSERT INTO ATMN_PRDSTG_TBLS.SALES_ONLINE ( TRNAS_WER_WER, TRNAS_SEGMENT, CONTACT_DATE , TRANS_STATUS ) VALUES ( :TRNAS_WER_WER, :TRNAS_SEGMENT, : CONTACT_DATE , :TRANS_STATUS ); 0014 .IMPORT INFILE /PRD/MLOAD/DATA/Online_sales_20191212.txt FORMAT VARCHAR '|' LAYOUT FILEIN APPLY INSERTS; 0015 .END MLOAD ================================================================ Multangad Initial Phase ================================================================= 09:33:35 UTY0829 options in effect for this MultiLoad irport task: Sessions: 9 session (s). Checkpointi 15 minute (s). Tenacity; 4 hour limit to successfully connect load sessions. Errlimit: No limit in effect. AmpCheck: In effect for apply phase transitions, ** 09:38:35 UTY0817 MultiLoad submitting the following request: Select NULL from ATMN_PRDSTG_TBLS.SALES_ONLINE_LOG where (LogType = 125) and (Seq = 1) and (MloadSeq = 0); 09:38:35 UTY0817 MultiLoad submitting the following request: Select NULL from ATMN_PRDSTG_TBLS.SALES_ONLINE_LOG where (LogIype = 120) and (Seq = 1); 09:38:37 UTY0817 MultiLoad submitting the following request: SET QUERY BAND='UTILITYNAME=MULTLOAD;' UPDATE FOR SESSION; ** 09:38:37 UTY0817 MultiLoad submitting the following request: CHECK WORKLOAD FOR BEGIN MLOAD ATMN_PRDSTG_TBLS.SALES_ONLINE; 09:38:37 UTY0817 MultiLoad submitting the following request: CHECK WORKLOAD END; 12:38:37 UTY0844 Session count 68 returned by the DBS overrides user-requested session count. 12:38:49 UTY0812 MLOAD session (3) requested: 68. 12:38:49 UTY0815 MLOAD session(s) connected: 68. 12:38:49 UTY0817 MultiLoad submitting the following request: BEGIN MLOAD ATMN_PRDSTG_TBLS.SALES_ONLINE WITH INTERVAL; 12:38:50 UTY0817 MultiLoad submitting the following request: INS ATMN_PRDSTG_TBLS.SALES_ONLINE_LOG (LogType, Seq, MLoadSeg) VALUES (130, 1, 10); 12:38:50 UTY0817 MultiLoad submitting the following request: MLOAD ATMN_PRDSTG_TBLS.SALES_ONLINE with ATMN_PRDSTG_TBLS.SALES_ONLINE_WT errortables ATMN_PRDSTG_TBLS.SALES_ONLINE_ET, ATMN_PRDSTG_TBLS.SALES_ONLINE_UV: MultiLoad DML Transaction Phase ================================================== == == ==MultiLoad DML Transaction Phase = = =========================== **** 13:38:55 UTY0817 MultiLoad submitting the following request: BT; *** 13:38:55 UTY0817 MultiLoad submitting the following request: USING TRNAS_WER_WER (VARCHAR (1000)), TRNAS_SEGMENT (VARCHAR (100)), CONTACT_DATE (VARCHAR (10)), TRANS_STATUS(VARCHAR (20)) INSERT INTO ATMN_PRDSTG_TBLS.SALES_ONLINE ( TRNAS_WER_WER, TRNAS_SEGMENT, CONTACT_DATE , TRANS_STATUS ) VALUES ( :TRNAS_WER_WER, :TRNAS_SEGMENT, : CONTACT_DATE , :TRANS_STATUS ); 09:38:59 UTY0817 MultiLoad submitting the following request: INS ATMN_PRDSTG_TBLS.SALES_ONLINE_LOG (LogType, Seq, MLoadSeg) VALUES (130, 1, 20); **** 09:38:59 UTY0817 MultiLoad submitting the following request: ET; =========================================================================== MultiLoad Acquisition Phase ============================================================================= UTY0817 MultiLoad submitting the following request: CHECKPOINT LOADING INTERVAL 1; CHECKPOINT LOADING INTERVAL 1; ********** 09:39:11 09:39:11 ******************** 09:39:11 09:39:11 ******************** ******************** ******************** 09:39:17 09:39:17 UTY0817 MultiLoad submitting the following request: UTY0817 MultiLoad submitting the following request: INS ATMN_PRDSTG_TBLS.SALES_ONLINE_LOG (LogType, Seq, INS ATMN_PRDSTG_TBLS.SALES_ONLINE_LOG (LogType, Seq, ******************** 09:39:17 09:39:17 UTY0817 MultiLoad submitting the following request: UTY0817 MultiLoad submitting the following request: ET; ET; =============================================================== MLOAD Application phase MLOAD Application phase ================================================================ ******************** 09:39:17 09:39:17 UTY0817 MultiLoad submitting the following request: UTY0817 MultiLoad submitting the following request: EXEC MLOAD ATMN_PRDSTG_TBLS.SALES_ONLINE; EXEC MLOAD ATMN_PRDSTG_TBLS.SALES_ONLINE; ****** 09:39:20 09:39:20 UTYOB19 Statistics for table UTY0818 Statistics for table Inserts: 8973 Inserts:8973 Updates: 0 Updates: 0 Deletes: 0 Deletes: 0 09:39:20 09:39:20 UTY1822 Application Phase statistics UTY1822 Application Phase statistics ******* 09:39:20 09:39:20 UTY0817 MultiLoad submitting the following request: UTY0817 MultiLoad substting the following request: INS ATMN_PRDSTG_TBLS.SALES_ONLINE_LOG (LOgType, Seg) VALUES INS ATMN_PRDSTG_TBLS.SALES_ONLINE_LOG (Lotype, Seg) VALUES ******* 09:39:20 09:39:20 UTY0817 MultiLoad submitting the following request: UTY0817 MultiLoad submitting the following request: BEGIN TRANSACTION; BEGIN TRANSACTION; ******* 09:39:20 09:39:20 UTY0817 MultiLoad submitting the following request: UTY0817 MultiLoad submitting the following request: END MLOAD; END MLOAD; ******* 09:39:20 09:39:20 UTY0817 MultiLoad submitting the following request: UTY0817 MultiLoad submitting the following request: INS ATMN_PRDSTG_TBLS.SALES_ONLINE_LOG (LOgType, Seg) VALUES INS ATMN_PRDSTG_TBLS.SALES_ONLINE_LOG (Lotype, Seg) VALUES ******* 09:39:22 09:39:22 UTY0817 MultiLoad submitting the following request: UTY0817 MultiLoad submitting the following request: Using Ckpt (varbyte (1024)) INS ATMN_PRDSTG_TBLS.SALES_ONLINE_LOG Using Ckpt (varbyte (1024)) INS ATMN_PRDSTG_TBLS.SALES_ONLINE_LOG ******* 09:39:22 09:39:22 UTY0817 MultiLoad submitting the following request: UTY0817 MultiLoad submitting the following request: END TRANSACTION; END TRANSACTION; =============================================================================== MULATI LOAD CLEANUP MULTI LOAD CLEANUP ============================================================================== **** **** 09:39:31 09:39:31 UTYO817 MultiLoad submitting the following request: UTY0817 Multiload submitting the following request: SELECT CAST (COUNT(*) AS BIGINT) FROM SELECT CAST (COUNT (*) AS BIGINT) FROM **** **** 09:39:33 09:39:33 UTY0821 Error table ATMN_PRDSTG_TBLS.SALES_ONLINE_ET is UTY0821 Error table ATMN_PRDSTG_TBLS.SALES_ONLINE_ET is ****** 09:39:33 09:39:33 UTY0817 MultiLoad submitting the following request: UTY0817 MultiLoad submitting the following request: BEGIN TRANSACTION; BEGIN TRANSACTION; 09:39:33 09:39:33 UTY0817 MultiLoad submitting the following request: UTY0817 MultiLoad submitting the following request: INS ATMN_PRDSTG_TBLS.SALES_ONLINE_LOG (LogType, Seq, INS ATMN_PRDSTG_TBLS.SALES_ONLINE_LOG (LogType, Seq, **** *** 09:39:33 09:39:33 UTY0817 MultiLoad submitting the following request: UTY0817 MultiLoad submitting the following request: DROP TABLE ATMN_PRDSTG_TBLS.SALES_ONLINE_ET; DROP TABLE ATMN_PRDSTG_TBLS.SALES_ONLINE_ET; 09:39:34 09:39:34 UTY0817 MultiLoad submitting the following requests: UT10817 MultiLoad submitting the following request: END TRANSACTION: END TRANSACTION: **** **** 09:39:34 09:39:34 UTYO817 MultiLoad submitting the following request: UTY0817 Multiload submitting the following request: SELECT CAST (COUNT(*) AS BIGINT) FROM SELECT CAST (COUNT (*) AS BIGINT) FROM **** **** 09:39:35 09:39:35 UTY0821 Error table ATMN_PRDSTG_TBLS.SALES_ONLINE_UV is UTY0821 Error table ATMN_PRDSTG_TBLS.SALES_ONLINE_UV is 09:39:35 09:39:35 UTY0817 MultiLoad submitting the following request: UTY0817 MultiLoad submitting the following request: BEGIN TRANSACTION; BEGIN TRANSACTION; ******* 09:39:35 09:39:35 UTY0817 MultiLoad submitting the following request: UTY0817 MultiLoad submitting the following request: INS ATMN_PRDSTG_TBLS.SALES_ONLINE_LOG (LogType, Seq, INS ATMN_PRDSTG_TBLS.SALES_ONLINE_LOG (LogType, Seq, *** 09:39:35 09:39:35 UTY0817 MultiLoad submitting the following request: UTY0817 MultiLoad submitting the following request: DROP TABLE ATMN_PRDSTG_TBLS.SALES_ONLINE_UV; DROP TABLE ATMN_PRDSTG_TBLS.SALES_ONLINE_UV; 09:39:35 09:39:35 UTY0817 MultiLoad submitting the following requests: UT10817 MultiLoad submitting the following request: END TRANSACTION: END TRANSACTION: **** **** 09:39:36 09:39:36 UTYO817 MultiLoad submitting the following request: UTY0817 Multiload submitting the following request: SELECT CAST (COUNT(*) AS BIGINT) FROM SELECT CAST (COUNT (*) AS BIGINT) FROM **** **** 09:39:36 09:39:36 UTY0821 Error table ATMN_PRDSTG_TBLS.SALES_ONLINE_WT is UTY0821 Error table ATMN_PRDSTG_TBLS.SALES_ONLINE_WT is 09:39:36 09:39:36 UTY0817 MultiLoad submitting the following request: UTY0817 MultiLoad submitting the following request: BEGIN TRANSACTION; BEGIN TRANSACTION; 09:39:36 09:39:36 UTY0817 MultiLoad submitting the following request: UTY0817 MultiLoad submitting the following request: INS ATMN_PRDSTG_TBLS.SALES_ONLINE_LOG (LogType, Seq, INS ATMN_PRDSTG_TBLS.SALES_ONLINE_LOG (LogType, Seq, **** *** 09:39:36 09:39:36 UTY0817 MultiLoad submitting the following request: UTY0817 MultiLoad submitting the following request: DROP TABLE ATMN_PRDSTG_TBLS.SALES_ONLINE_WT; DROP TABLE ATMN_PRDSTG_TBLS.SALES_ONLINE_WT; 09:39:36 09:39:36 UTY0817 MultiLoad submitting the following requests: UT10817 MultiLoad submitting the following request: END TRANSACTION: END TRANSACTION: ***** **** 09:39:37 09:39:37 UTY0825 Error table statics for: UTY0825 Error table statics for: Target table 1: ATMN_PRDSTG_TBLS.SALES_ONLINE Target table 1: ATMN_PRDSTG_TBLS.SALES_ONLINE 0 ATMN_PRDSTG_TBLS.SALES_ONLINE_ET 0 ATMN_PRDSTG_TBLS.SALES_ONLINE_ET 0 ATMN_PRDSTG_TBLS.SALES_ONLINE_UV 0 ATMN_PRDSTG_TBLS.SALES_ONLINE_UV 09:39:37 09:39:37 UTY0817 MultiLoad submitting the following requests: UT10817 MultiLoad submitting the following request: BEGIN TRANSACTION; BEGIN TRANSACTION; 09:39:37 09:39:37 UTY0817 MultiLoad submitting the following requests: UT10817 MultiLoad submitting the following request: Using Ckpt (varbyte (1024)) INS ATMN_PRDSTG_TBLS.SALES_ONLINE_LOG Using Ckpt (varbyte (1024)) INS ATMN_PRDSTG_TBLS.SALES_ONLINE_LOG 09:39:37 09:39:37 UTY0817 MultiLoad submitting the following requests: UT10817 MultiLoad submitting the following request: INS ATMN_PRDSTG_TBLS.SALES_ONLINE(LogType, Seq) VALUES INS ATMN_PRDSTG_TBLS.SALES_ONLINE_LOG (LogType, Seq) VALUES 09:39:37 09:39:37 UTY0817 MultiLoad submitting the following requests: UT10817 MultiLoad submitting the following request: END TRANSACTION; END TRANSACTION; =================================================== MultiLoad Task Complete MultiLoad Task Complete ==================================================== 09:39:45 09:39:45 UTY1024 Session modal request, 'SET UTY1024 Session modal request, 'SET ====================================================== Processing Control Statements Processing Control Statements ========================================================= 0016 0016 .SET RC to 0: .SLT RC to 0; UT12408 Error occurred while trying to record control output intonation - terminating. 12/13/1910 9:39:451 /production/code/bin/ONLINESALES | main MLOAD FAILED