 |
 |
Archives of the TeradataForum
Message Posted: Wed, 29 Jun 2005 @ 13:41:58 GMT
| Subj: | | Re: FASTLOAD Q: Check points |
| |
| From: | | Reddy, Sridhar |
HI Anantha,
| | 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? | |
# You have resubmit the job. But, Make sure you do not drop those ErrorTables (err1,err2). (Its general tendency to write Drop table stmts to
drop all existing error tables at the beginning of the script)
| | 2. How do we know the last record that was checkpointed? | |
# FL automatically read Restart Log to Determine where to start (it stats after last Check Point)
| | 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? | |
# Database Restart, Client System Failure, Out Of Space etc. Yes Out Of Space is one of them.
Thanks,
Sridhar
| |
