Archives of the TeradataForum

Message Posted: Wed, 03 Jan 2007 @ 11:23:58 GMT

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

"LastAlter" means DDL (like ALTER TABLE or CREATE INDEX), not DML (like UPDATE or INSERT).

"LastAccessTimeStamp" can be activated via DBSControl option, but would include SELECT.

DBQL is activated by user or account (NOT by table), and OBJECT level data is optional.

If there are specific tables you wish to track, Access Logging might be a better fit than DBQL.

Neither DBQL nor AccessLog will tell you which rows or values were updated (unless you log the SQL and it happens to have all the relevant info specified as constants), just that some update or insert occurred.

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