 |
 |
Archives of the TeradataForum
Message Posted: Wed, 29 Jun 2005 @ 13:26:01 GMT
| Subj: | | Re: FASTLOAD Q: Check points |
| |
| From: | | Victor Sokovin |
| | 1. If we checkpoint loading at intervals, and the FL gets interrupted, how do we restart it? should we just relaunch the FL job script
again? Or should we truncate the data file till the last checked point? | |
Just restart and let TD do the job.
| | 2. How do we know the last record that was checkpointed? | |
Good question. I don't know. Probably because I was never particularly interested in this. See above.
| | 3. what are the scenarios under which a FL job script might get interrupted? will the database running out of space be one among
them? | |
That would be one of the typical reasons. File layout, problems with data types, field lengths etc would be other reasons.
If the input file requires editing, I for one forget about any committed checkpoints in this case and repeat the FL job from scratch on the new
version of the file.
Regards,
Victor
| |
