Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 11 Oct 2002 @ 10:09:13 GMT


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


Subj:   Checkpointing in TPUMP
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, October 09, 2002 23:58 -->

What exactly is the difference between taking checkpoints or not taking checkpoints in a TPUMP job?

The manual says

* CHECKPOINT 0, checkpointing will be bypassed for the duration of IMPORT

* When frequency is not mentioned, checkpointing occurs every 15 minutes

* When frequency is mentioned (say x minutes) , checkpointing is done at end of ever x minutes.

I understand that while we load a table with TPUMP, the rows are inserted into the teradata table as they are processed (trickle feed). Also if TPUMP job is abended, it can be restarted and the TPUMP log will be used to process remaining records (implicit checkpointing). Then what is the use of Checkpointing?

Thanks & Regards



     
  <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: 15 Jun 2023