Ending DBQL Logging for Specific Users and/or Accounts
When you are ready to stop logging, specify any accounts on which you enabled DBQL logging. For example, if you submitted the following statement:
BEGIN QUERY LOGGING WITH OBJECTS ON APPLNAME='FASTLOAD';
to stop logging, use:
END QUERY LOGGING ON APPLNAME='FASTLOAD';
Teradata recommends using scripts to enable and disable logging to avoid typographical errors.
Note: The application names you specify with the APPLNAME option are the names the system passes in the LogonSource string. (For a list of the commonly seen LogonSource string application names, see “Application Names” in SQL Data Definition Language.)