The Load operator takes checkpoints at the beginning and end of the acquisition phase. More granular checkpoints during the acquisition phase can be specified using the command line option -z when running Teradata PT using the tbuild command. The -z option specifies checkpoint intervals in terms of seconds.
The following command string is an example of the -z option:
tbuild -f <file name> -z 30
In this command, the -f option indicates the script that is input to tbuild, and the -z option indicates that a checkpoint will be taken every 30 seconds.
The DEFINE JOB statement can also be used to specify a checkpoint value.
Checkpointing during the application phase is managed internally by Advanced SQL Engine, and therefore is not user-controlled.