Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 24 Jul 2002 @ 14:41:14 GMT


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


Subj:   Access Logging and changing the log table
 
From:   Sam Sterling

I know that some sites have parts of Access Logging turned on to capture SQL that is submitted. I've also heard that some sites have changed the Primary Index to TheDate, TheTime, rather than LogonDate, LogonTime which has caused serious hot amp problems at some sites.

So, what I'm asking is how do you change the PI (since DBC doesn't seem to have drop table).

And, what do you put into AccessLogRights?


Thanks.

Sam Sterling



     
  <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