Archives of the TeradataForum

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

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

<-- 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>>