Checkpoint Tradeoffs | Teradata FastLoad - 17.10 - Checkpoint Tradeoffs - FastLoad

Teradata® FastLoad Reference

Product
FastLoad
Release Number
17.10
Published
June 2021
Last Update
2021-07-01
Content Type
Programming Reference
Publication ID
B035-2411-061K
Language
English (United States)
Though the checkpoint feature substantially enhances Teradata FastLoad restart operations, it also reduces the speed of the Teradata FastLoad job. Always consider the following factors when deciding how often to specify checkpoints:
  • Each checkpoint temporarily halts the multiple session data transfer feature of Teradata FastLoad, thereby decreasing the speed of the Teradata FastLoad job.
  • For each checkpoint, Teradata FastLoad waits for each session to complete sending its current request, which interrupts the data transfer operation.
  • The record size and the size of the database influence how often checkpoints should be specified. On a smaller database, specify checkpoints:
    • Every 50,000 records if each record is more then 4 KB
    • Every 100,000 records if each record is less than 4 KB

      On a larger database, specify higher (less frequent) checkpoint values.