Archives of the TeradataForum

Message Posted: Thu, 05 Jul 2012 @ 09:25:01 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Mirajkir,

You have three practical choices.

1) Enable the ObjectUseCount feature. If this is done then you simply look for tables where the LastAccessdate is older than 90 days.

2) Enable DBQL logging using the OBJECT option which will generate rows in the DBQLObjTbl table.

3) Enable Access logging which will generate rows in the AccLogTbl table.

Using option 2 or 3 will require some SQL using a NOT IN or NOT EXISTS predicate against a sub-query.

Each of the above probably have their own pro's and cons.

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

	<Prev	Next>		<<First	<Prev	Next>	Last>>