Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Where are executed querys found in dbc?
From:   McCall, Glenn D

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
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020