Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 28 Feb 2008 @ 08:43:18 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: MLOAD application phase
 
From:   OmerAl

My apologies for not sending enough information:

Following is the output from the log:


     /**************************************************************************/
     ------------------------------------------------------------------------
     =                                                                      =
     =          MultiLoad Acquisition Phase                                 =
     =                                                                      =
     ------------------------------------------------------------------------
     **** 05:29:21 UTY0817 MultiLoad submitting the following request:
           BEGIN TRANSACTION;
     **** 05:29:21 UTY0817 MultiLoad submitting the following request:
           CHECKPOINT LOADING INTERVAL 0;
     **** 05:29:21 UTY0817 MultiLoad submitting the following request:
           CHECKPOINT LOADING INTERVAL 0;
     **** 05:29:21 UTY0817 MultiLoad submitting the following request:
           CHECKPOINT LOADING INTERVAL 0;
     **** 05:29:22 UTY0817 MultiLoad submitting the following request:
           USING Ckpt(VARBYTE(1024)) INSERT P0_LOG.ML_EVENT  (Logtype, Seq, MLoadSeq,
           MLoadImpSeq, MLoadSrcSeq, MiscInt1,MiscInt2,MiscInt3,MiscInt4,
           MiscInt5,MiscInt6,MiscInt7,MiscInt8,CkptInterval,MLoadCkpt) VALUES (110, 1,
           0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, :Ckpt);
     **** 05:29:24 UTY1802 Processing Import Sequence 1, Source Sequence 100000.
     **** 05:29:25 UTY1802 Processing Import Sequence 1, Source Sequence 200000.
     **** 05:29:26 UTY1802 Processing Import Sequence 1, Source Sequence 300000.
     **** 05:29:27 UTY1802 Processing Import Sequence 1, Source Sequence 400000.
     **** 05:29:27 UTY0817 MultiLoad submitting the following request:
           CHECKPOINT LOADING INTERVAL 0;
     **** 05:29:28 UTY0817 MultiLoad submitting the following request:
           USING Ckpt(VARBYTE(1024)) INSERT P0_LOG.ML_EVENT  (Logtype, Seq, MLoadSeq,
           MLoadImpSeq, MLoadSrcSeq, MiscInt1,MiscInt2,MiscInt3,MiscInt4,
           MiscInt5,MiscInt6,MiscInt7,MiscInt8,CkptInterval,MLoadCkpt) VALUES (110, 1,
           1, 1, 0, 417665, 417665, 417665, 417665, 0, 0, 0, 0, 0, :Ckpt);
     **** 05:29:28 UTY0826 A checkpoint has been taken, recording that end of
           file has been reached
           for IMPORT 1 of this MultiLoad Import task.
     **** 05:29:28 UTY1803 Import processing statistics
           .                                       IMPORT  1     Total thus far
           .                                       --------=     --------------
           Candidate records considered:........      417665.......      417665
           Apply conditions satisfied:..........      417665.......      417665
           Candidate records not applied:.......           0.......           0
           Candidate records rejected:..........           0.......           0
     **** 05:29:28 UTY0817 MultiLoad submitting the following request:
           CHECKPOINT LOADING INTERVAL 0;
     **** 05:29:28 UTY0817 MultiLoad submitting the following request:
           CHECKPOINT LOADING INTERVAL 0 END;
     **** 05:29:54 UTY0817 MultiLoad submitting the following request:
           INS P0_LOG.ML_EVENT (LogType, Seq, MLoadSeq)VALUES(130, 1, 30);
     **** 05:29:55 UTY0817 MultiLoad submitting the following request:
           ET;

     ------------------------------------------------------------------------
     =                                                                      =
     =          MultiLoad Application Phase                                 =
     =                                                                      =
     ------------------------------------------------------------------------
     **** 05:29:55 UTY0817 MultiLoad submitting the following request:
           EXEC MLOAD P0_EDW_MB.EVENT;
     **** 06:00:14 UTY0818 Statistics for table P0_EDW_MB.EVENT:
              Inserts:       417665
              Updates:            0
              Deletes:            0
     **** 06:00:14 UTY0817 MultiLoad submitting the following request:
           INS P0_LOG.ML_EVENT (LogType, Seq) VALUES (115, 1)
     **** 06:00:14 UTY0817 MultiLoad submitting the following request:
           BEGIN TRANSACTION;
     **** 06:00:14 UTY0817 MultiLoad submitting the following request:
           END MLOAD;
     **** 06:00:44 UTY0817 MultiLoad submitting the following request:
           INS P0_LOG.ML_EVENT (LogType, Seq) VALUES (120, 1)
     **** 06:00:44 UTY0817 MultiLoad submitting the following request:
           USING Ckpt(VARBYTE(1024)) INS P0_LOG.ML_EVENT (LogType, Seq,
           MLoadCkpt)VALUES(135, 1, :Ckpt);
     **** 06:00:44 UTY0817 MultiLoad submitting the following request:
           END TRANSACTION;

     ------------------------------------------------------------------------
     =                                                                      =
     =          MultiLoad Task Cleanup                                      =
     =                                                                      =
     ------------------------------------------------------------------------
     **** 06:00:44 UTY0817 MultiLoad submitting the following request:
           SELECT COUNT(*) FROM P0_ERR.ET_EVENT;
     **** 06:00:45 UTY0821 Error table P0_ERR.ET_EVENT is EMPTY, dropping table.
     **** 06:00:45 UTY0817 MultiLoad submitting the following request:
           BEGIN TRANSACTION;
     **** 06:00:45 UTY0817 MultiLoad submitting the following request:
           INS P0_LOG.ML_EVENT (LogType, Seq, MLoadSeq)VALUES(125, 1, 1)
     **** 06:00:45 UTY0817 MultiLoad submitting the following request:
           DROP TABLE P0_ERR.ET_EVENT;
     **** 06:00:47 UTY0817 MultiLoad submitting the following request:
           END TRANSACTION;
     **** 06:00:48 UTY0817 MultiLoad submitting the following request:
           SELECT COUNT(*) FROM P0_ERR.UV_EVENT;
     **** 06:00:48 UTY0821 Error table P0_ERR.UV_EVENT is EMPTY, dropping table.
     **** 06:00:48 UTY0817 MultiLoad submitting the following request:
           BEGIN TRANSACTION;
     **** 06:00:48 UTY0817 MultiLoad submitting the following request:
           INS P0_LOG.ML_EVENT (LogType, Seq, MLoadSeq)VALUES(125, 1, 2)
     **** 06:00:48 UTY0817 MultiLoad submitting the following request:
           DROP TABLE P0_ERR.UV_EVENT;
     **** 06:00:54 UTY0817 MultiLoad submitting the following request:
           END TRANSACTION;
     **** 06:00:54 UTY0817 MultiLoad submitting the following request:
           BEGIN TRANSACTION;
     **** 06:00:54 UTY0817 MultiLoad submitting the following request:
           INS P0_LOG.ML_EVENT (LogType, Seq, MLoadSeq)VALUES(125, 1, 3)
     **** 06:00:55 UTY0817 MultiLoad submitting the following request:
           DROP TABLE P0_WRK.WT_EVENT;
     **** 06:00:56 UTY0817 MultiLoad submitting the following request:
           END TRANSACTION;
     **** 06:00:56 UTY0825 Error table statistics for:

           Target table 1: P0_EDW_MB.EVENT
           Number of Rows  Error Table Name
           --------------
     --------------------------------------------------------
                        0  P0_ERR.ET_EVENT
                        0  P0_ERR.UV_EVENT

     /**************************************************************************/

- The target table has only on UPI and no NUSIs.

- The input data row is not very long I suppose, there are 20 fields out of which 10 are NULL. But the data is not skewed at all.

- We have a single node system only with 7 AMPs.

- We are using "Release MLOD.07.06.02.000"


Thanks.


Regards,

Omer Alvi



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019