Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 03 Jan 2007 @ 17:08:51 GMT


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


Subj:   Re: Username and last modified information for a particular table
 
From:   Geoffrey Rommel

  how can we see in Teradata the last update/inserts and access information with time stamp and the user id used for this purpose for a particular table?  


I don't know of any RDBMS that automatically tracks the last update, etc., on every column of every row of every table. This would probably add a lot of overhead for relatively little value; hence it is left up to the customer to track these things when they are really needed.


  Why we do not always have entry on DBC.Tables for all the tables/views? What we need to do to have entry on this view for all the tables of the databases (entry for LastAlterName. LastAlterTimeStamp, LastAccessTimeStamp).  


I believe your question is: "Why don't LastAlterName and LastAlterTimeStamp change whenever anyone changes any data in the table?" The LastAlter columns track changes to the structure of the table (columns added or dropped, for instance), not changes to the data.


  Is there any way we can find these from DBQL for a particular table?  


Yes, if DBQL is logging everything, you can infer when changes took place to the data, but there are complications. (1) Most update statements change more than one row, so it may be difficult or impossible after the fact to determine exactly which rows were changed. (2) FastLoad and MultiLoad do not perform ordinary insert statements, so in general you can't tell which rows were inserted when.

If tracking changes to individual rows is important to you, you'll have to include updates to the user ID and timestamp in your application.



     
  <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