All Forums Database
badithya 9 posts Joined 05/09
17 Jul 2012
How to know last one hour transation what you did on the teradata database

Suppose we are insrting and deleting and update no of record in teradata in a day but i want only last one hour transation what we did?

what is the query for taht?
 

Qaisar Kiani 337 posts Joined 11/05
18 Jul 2012

You need to check the DBQL Log tables, they track the SQLs that has been executed on the system and you can put a filter on the user for which you want to see the results.

SELECT *
FROM DBC.DBQLSQLTBL 
WHERE COLLECTTIMESTAMP >= CURRENT_TIMESTAMP - INTERVAL '1' HOUR
AND USER_ID = '<<USER_ID>>'

 

You must sign in to leave a comment.