If CHECKPOINT is set to 0:
For some tape drives, tape positioning information is not available or is very expensive. Setting CHECKPOINT to 0 allows more efficient processing in these cases.
Note: Setting CHECKPOINT to 0 is not the same as setting CHECKPOINT to a very large number. If CHECKPOINT is set to a very large number, Teradata ARC still saves some checkpoint information in the restart log, such as the beginning of database/table, and restart/reconnect is supported at database/table boundaries.
Note: Some applications that use Teradata ARC do not support positioning activity. To prevent positioning activity, set CHECKPOINT to 0.