Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 06 Jul 2011 @ 08:43:24 GMT


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


Subj:   Re: BEGIN QUERY LOGGING
 
From:   Yong Boon

Faible,

The query logging (DBQL) could be started either on individual user level or all users on the system level, i.e.


User Level -

     BEGIN QUERY LOGGING WITH  ON  ....;

System Level -

     BEGIN QUERY LOGGING WITH  ON ALL ....;

And different logging option are available ALL, EXPLAIN, OBJECTS, SQL, STEPINFO, XMLPLAN.

Evaluate your requirement of turning on the DBQL and set the DBQL at the desired level with the right option considering the volume of data generated by different logging option.

If your requirement is for audit purpose, do consider using Access Log instead of DBQL.

Besides, it's prefer to set the DBQL at the user level rather than system level, which give you the flexibility to switch the logging option for the individual users when detailed logging information are needed for particular user SQL tuning purpose. However, you have to remember to enable the DBQL for each newly created users.

Hope this help.


Regards,

YB



     
  <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