Teradata, turning off query logging(DBC.QRYLOG) for SQL's

Database
N/A

Teradata, turning off query logging(DBC.QRYLOG) for SQL's

Hi,

Is there anyway we could prevent SQL's from getting logged in the DBC.QRYLOG table. I mean not switching off the query logging, but preventing the individual SQL's from getting logged. If thats not possible, please let me know how to turn off query logging? and are administrative privileges mandatory to do that?

Thank you for your help.

- Jay.
2 REPLIES
Senior Apprentice

Re: Teradata, turning off query logging(DBC.QRYLOG) for SQL's

Q1: no
Q2: yes

Query Logging is controlled on a User/Account Level and can't be disabled for "individual" queries.

Please contact your friendly DBA for further assistance :-)

Dieter
Enthusiast

Re: Teradata, turning off query logging(DBC.QRYLOG) for SQL's

I could not able to find any data in qrylog table for my perticular session.  I need this information. Can any one guide me about the qrylog table. How it load data and when it refresh. can i get the data based on my teradata session id??