FastLoad Checkpoint

Tools

FastLoad Checkpoint

Hi,

I am writing a fastload job script to load data into target table.If I include checkpoint option will it be useful.

Thanks and Regards,
Gowda C H
2 REPLIES
Enthusiast

Re: FastLoad Checkpoint

Hi

Just a quick tip, if your Checkpoint is set to below 60 it defaults to minutes not records!
So you might not want a checkpoint every 2 minutes, would you?

Rememebr Checkpoint has got to do with falling abck if the job fall over. If you have a checkpoint of 1,000,000 and your job falls over at 1,999,998 you will only have 1,000,000 records in the table. Now also do not make in 100 because tehn you job could be checkpointing more than it is working. You need to play with the checkpoint value and get one that suits you

Divvy
Enthusiast

Re: FastLoad Checkpoint

Please refer to this post for more recent and accurate information:

http://forums.teradata.com/forum/tools/how-to-select-sessionstenacitysleepcheckpoint-etc-for-fastloa...

(Checkpoint freq for Fast Load does not assume minutes when the setting is less than 60, like MLOAD does).