Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 10 Jul 2001 @ 08:03:36 GMT


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


Subj:   Re: Cleaning out Resusage Tables
 
From:   David Wellman

Patricia,

In the past I have always warned against using Multiload to purge Resusage tables or indeed any tables in DBC. This is because if the Multiload task fails during Apply phase then you have a locked table which has to be dropped and re-created. With most of the system tables, this means a Sysinit!

However, since release 'X' of Teradata/Multiload (no, I can't remember which one), you are able to issue the "Release MLoad" command even if the task failed during the Apply phase. Having said that, the user (i.e. you) then have to ensure data integrity etc etc. Personally, I still wouldn't use Multiload against a system table.


Cheers,

Dave



     
  <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: 15 Jun 2023