Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 14 Jun 2004 @ 18:26:34 GMT


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


Subj:   Re: How to find tables not backed up
 
From:   Dan Narva

Unless you have a way of parsing your output from the archive utility, I don't believe you can get info in DBC.RCEVENTS at the table level if you archive at the database level. If you archive at the table level, you do get that info, as you may have observed.

One noteworthy column in RCEVENTS is the flag "OperationInProcess". It will be "N" if your dump/restore operation completed, otherwise it will be "Y". That way you can distinguish archives that successfully completed vs. the probably rare occasions where they did not (e.g., by cancellation).


Dan



     
  <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