ON - Advanced SQL Engine - Teradata Database

Keyword that precedes scope of logging for users, accounts, databases, or applications.

ALL

Logging for all users. The system logs each request performed for every user on the system. If you specify the USECOUNT option, logging is performed for all databases.

user_name

Name of one or more users for whom SQL request information is to be logged. The maximum number of individual user names you can specify in a single BEGIN QUERY LOGGING request is 100.

The more users you specify, the greater the impact on system performance.

If you specify a user_name with USECOUNT, the use count information for objects in the user database is logged, regardless of the user accessing the objects. If users access objects in another database, use count information is not logged unless the USECOUNT option is also specified for the containing database.

database_name

Name of one or more databases for which object use count data is to be logged.

ACCOUNT = ‘account_string’

Set of user accounts for which SQL request information is to be logged for the specified user_name.

APPLNAME = ‘application_name’

Logging is enabled or disabled for any user who logs on under the specified application name set.

Application names are the names the system passes in the UtilityName query band. See "Reserved Load Utility Reserved Query Bands" in Teradata Vantage™ - SQL Data Definition Language Detailed Topics , B035-1184 .