Check SQL history in Teradata

Checking SQL history in Teradata can be very important.Few of the key points can be :

  • Check commands you executed in Teradata.
  • Check commands executed by other users in Teradata.
  • Who modified any object like table etc in Teradata.
  • When some SQL commands were executed in Teradata.
  • From which IP SQL commands were executed in Teradata.
  • Top resource consuming queries in Teradata.

To check SQL History in Teradata, we refer to dbc.QryLog. DBC.QryLog is a view which contains information about the SQL Queries executed in Teradata.We can use the below mentioned query for checking history of SQL queries you executed in Teradata.

select * from dbc.Qrylog where clientid='YOUR NAME'  order by StartTime desc;

The output of the above query contains lots of columns and you can check these columns and then select columns which you need for your analysis. Try this query and I am sure it is very useful for any person who is working on Teradata. If you are looking for information on how much resources queries took in any given session then I will recommend you to check this post with more details: Top Resource Consuming queries in Teradata.

Leave a Reply

Your email address will not be published. Required fields are marked *