View's base table timestamp

General
N/A

View's base table timestamp

Hi,

I am finding out set of view's base table's last access timestamp. Right now I do

1. show view on the view name

2. Get the table name from the result

3. And find the table's last access time stamp from dbc.tables

Since there are a lot of views, for whose base tables i am finding the last access timestamp, Is there any other easier way to do this.

Tags (2)
2 REPLIES

Re: View's base table timestamp

Have you tried getting it from PDCRinfo.dbqlobjtbl_hst

N/A

Re: View's base table timestamp

Thank you.

I have insufficent access to this table. So.. is there anyother wayout??