I have a requirement to find the part of the table (the real data) which are been accessed before a given logdate. A part of the data in a table are not at all accessed lately..
they were accessed long before where we have the queryid to track it.. but want the real data that came as output as part of this old query without triggering the same query again.
Table A has 100 records where 50 are ACTIVE, 50 are with INACTIVE status and off late, users have been accessing only the ACTIVE records..
The 50 INACTIVE records were not at all queried. lets say these 50 records were queried 100 days back through SELECT statement.
How to trace back these exact 50 records.
Inputs i have :-
Tablename, logdate, query id (dbqlogtbl_hst)
Hurdles I am facing:-
PDCRINFO.DBQLOGTBL_HST has only query id, querytxt, numresultrows... but NOT THE EXACT DATA..
how to find the connection between the queryid (i have the queryid from 100 days back) and the exact data in a table, how we can narrow down to the real data in the table.
Condition :- I dont want to re-execute the query and find the data.
Got the object id, queryid from PDCRINFO.DBQOBJTBL_HST, PDCRINFO.DBQLOGTBL_HST..
Got the rowhash (primary index) to connect to the table....
but got lost on how to connect between these two.
is there any table or query with which we can find the connection between queryid and rowhash(pi)
Solved! Go to Solution.
That's a nice idea, Teradata sales people will like it, when you switch it on you will need muuuch bigger systems to store all that info :-)