Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 09 Aug 2001 @ 15:04:13 GMT


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


Subj:   Re: Fastload vs Multiload
 
From:   Jim Downey

The following seems to work at our site because we have userids that only do multi-loads. The last alter name then contains the last id to alter the table. It looks to me that inserting rows meets this condition. Assuming no other activity has taken place, this would identify which tables had been multi loaded by the multi load id.

SEL  *
FROM DBC.TABLES
WHERE     DATABASENAME='DATABASENAME'
WHERE     LASTALTERNAME='MLOADID'
;

If that doesn't work, the following will identify when the multi load log file had rows inserted and then was dropped. The logfile name is the one listed in the .LOG statement in the multi load script. We use a naming convention that just appends _log to the end of the table name that is being multiloaded.

SEL  *
FROM DBC.ACCESSLOG
WHERE     DATABASENAME='DBNAME'
AND  TVMNAME='LOGTABLENAME'
;


     
  <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: 27 Dec 2016