17.10 - Fallback Data File Space Requirements - Access Module

Teradata® Tools and Utilities Access Module Reference

Product
Access Module
Release Number
17.10
Published
October 2021
Language
English (United States)
Last Update
2021-11-02
dita:mapPath
uur1608578381725.ditamap
dita:ditavalPath
obe1474387269547.ditaval

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 Teradata Access Module for Named Pipes 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.

Example: Fallback Data File

The Teradata FastLoad Reference (B035-2411) recommends checkpoints be taken as follows:
  • Every 100,000 records if each record is less than 4 KB
  • Every 50,000 records if each record is more than 4 KB

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.