I am still learning TD so I apologize if this is an 'easy' one. I need the following information so I can see if there are any old tables I can drop to reclaim space. I think I need to join DBC.Tables and DBC.TableSize but having issues doing so. I would like to see tables from multiple databases, but if I have to do it one-by-one then that is fine. Any help is appreciated!
We have tablename & Databasename in both dbc.tables & dbc.tablesize. Please find the Code, that will give you the Tablename,Databasenaem,Creatorname,Lastaccesstimestamp & Currentperm.
sel b.databasename,a.tablename,a.CreatorName,a.CreateTimeStamp,a.LastAccessTimeStamp,sum(currentperm)/(1024*1024) from dbc.tables a
group by 1,2,3,4,5
Thanks & Regards,
I checked earlier too but all the entries of lastaccesstimestamp in dbc.tables comes as null in my application..
Is there any way to activate it or is it automatic ?
ObjectUseCountCollectRate is enabled(>0), Usecount is also enabled, but still i could find LastAccesstimestamp= null for few tables in a DB.
I observed if a table is defined on a NOPI, then LastAccesstimestamp=NULL, Somebody correct me here please.
If an object existed prior to turning on usecount, and it has not been accessed since usecount was turned on, then the last access will still be null.