Fallback Data File Space Requirements
The fallback data file requires enough space to save all of the data between two successive checkpoints. If the directory that you specify for the fallback data file does not have enough free space to save all of the data read during the checkpoint interval, then the Named Pipes Access Module will not be able to provide all of the data to support a subsequent restart operation.
Always specify a directory for the fallback data file that has enough free space to store all of the data expected during the checkpoint interval.
The Teradata FastLoad Reference (B035‑2411) recommends checkpoints be taken as follows:
These guidelines imply that the fallback data file should range from 200 to 400 Mb in size for small‑ to medium‑sized databases. For large databases, the fallback data file might need to be 1 Gb or greater.