Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 09 Sep 2008 @ 12:43:21 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020