Archives of the TeradataForum

Message Posted: Wed, 06 Jul 2011 @ 08:43:24 GMT

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

Faible,

The query logging (DBQL) could be started either on individual user level or all users on the system level, i.e.

User Level -

     BEGIN QUERY LOGGING WITH  ON  ....;

System Level -

     BEGIN QUERY LOGGING WITH  ON ALL ....;

And different logging option are available ALL, EXPLAIN, OBJECTS, SQL, STEPINFO, XMLPLAN.

Evaluate your requirement of turning on the DBQL and set the DBQL at the desired level with the right option considering the volume of data generated by different logging option.

If your requirement is for audit purpose, do consider using Access Log instead of DBQL.

Besides, it's prefer to set the DBQL at the user level rather than system level, which give you the flexibility to switch the logging option for the individual users when detailed logging information are needed for particular user SQL tuning purpose. However, you have to remember to enable the DBQL for each newly created users.

Hope this help.

Regards,

YB

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