Archives of the TeradataForum
Message Posted: Tue, 09 Sep 2008 @ 12:43:21 GMT
| Subj: | | Re: Checking Fast Load job status |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Mon, 8 Sep 2008 10:20 -->
FastLoad and MultiLoad update table headers to a "pending load" status. That's how the database recognizes the table as "being loaded" even if
the load job has failed and is no longer running.
FastLoad checkpoint information is stored in the SysAdmin.FastLog system table. MultiLoad checkpoint information is stored in the logtable
specified when you invoke the utility.
The CheckTable utility can report pending status, but has to be run from the database window or multitool and is not something you want to
casually execute. Better to check return codes or SQL codes in the first place.
| 
