Archives of the TeradataForum
Message Posted: Tue, 09 Sep 2008 @ 12:43:21 GMT
<-- 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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|