Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 23 Jul 2003 @ 14:19:34 GMT


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


Subj:   Re: Locking Log
 
From:   Dieter N�th

Ferry, Craig wrote:

  Is there a way to capture all the SQLs currently running on the database?  



Before V2R5 there's BEGIN LOGGING, in V2R5 it's BEGIN QUERY LOGGING with enhanced capabilities (and less overhead when you just collect info similar to BEGIN LOGGING).

But be carefull not to collect for every user, e.g. load users.

For details check the Administration manual.


Dieter



     
  <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