Checkpoint in FastLoad


Checkpoint in FastLoad

Hi all,

I running a fastload which loads the data from a flat file. Size of the file is 25Gb and it consists of 14 billions records.

Can CHECKPOINT value makes a difference to speed up the fastload process. Is there any standard way to specify the number records in CHEKCPOINT like 20% of total records in a file.


Kamlesh Khollam


Re: Checkpoint in FastLoad

Checkpoints slow FastLoad processing.Set the CHECKPOINT large enough that checkpoints are taken every 10 to 15 minutes.  Usually, this requires a CHECKPOINT value much larger than 100,000.

Refer the below link for more info....