on_items - Analytics Database - Teradata Vantage

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantage™

Specify scope of logging for users, accounts, databases, or applications:

Item Description
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 Teradata Vantage™ - SQL Data Definition Language Detailed Topics, B035-1184.