Archives of the TeradataForum

Message Posted: Mon, 27 Jul 2003 @ 23:13:52 GMT

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

Hi Jake, the feature you are looking for is Logging. This feature is described in the SQL Reference manual set (Volume 4 - Data Definition Statements). Look for it in chapter 1 under the heading "BEGIN LOGGING" (both V2R4 and V2R5).

V2R5 has an additional feature "Query Logging" (which I have not used yet) and appears to provide a lot more detail.

You will find the output of "BEGIN LOGGING" in a table DBC.accesslog. Note that to enable access logging ("begin logging") your teradata will need to be setup correctly. This involves the installation of DIPACC DBCSQL script and resetting the system. Both the V2R5 and V2R4 manual makes mention of this.

I hope this is of some help.

Glenn Mc

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