Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Fri, 21 Dec 2002 @ 02:28:09 GMT


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


Subj:   Re: V2R5 Query Log vs Ambeo Usage Tracker
 
From:   Walter, Todd A

Access Log is syncronous with the request, in fact the request is not allowed to succeed until the access log entry (if any) is sucessfully completed. Otherwise, creative people could start a query, get part of the answer and then abort it aborting the access log write as well. Not allowable.

Query Log is much more relaxed. It is buffered and written independently of the request because it's requirements are not as stringent. This also allows some buffered writes which improves the overall cost of the facility.

The priority of the logging cannot be controlled. It is an internal function. Even if the priority could be controlled, it would not change the *cost* of the logging. It might change the impact to other work but that is not likely as long as logging is not turned on for the very short requests (single row selects, Tpump,...).



     
  <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: 28 Jun 2020