Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 09 Jul 2001 @ 15:25:44 GMT

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

Subj:   Re: Multiload & checkpoint
From:   Fred Pluebell

Christopher Platt wrote:

  Question : Does multiload store incoming transactions in the wt.table until either a checkpoint is forced or it hits the system default of 15 minutes???  

During the Acquire phase, MLOAD stores all "transactions" in the WorkTable. This space is not released until MLOAD completes; CHECKPOINT is not a factor. WorkTable rows are hashed based on the PI of the target table.

  Question2 : I have also recommended that he add his NUSI's after the load and he will get better performance.... (feedback??)  

Maybe. And if you're running out of WorkTable space during the Apply phase, this is the workaround. In the first part of the Apply phase, MLOAD applies changes to the table rows and records all corresponding NUSI updates in the WorkTable, to be applied in the second part of the Apply phase. Again, these NUSI "transactions" remain in the WorkTable until MLOAD completes.

  <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: 28 Jun 2020