SQL logging is based on by the type of work being performed. In general, all Teradata Active EDW workloads can be broadly grouped into three categories as follows:
This workload can be identified by work typically done by TPUMP and single-AMP, subsecond tactical requests only.
This workload can be identified by work typically done by SQL Assistant, Teradata Studio, Report Applications, MultiLoads, FastLoads, and BTEQ. It is typical mixed workload usage.
This workload can be identified by usage that is typically tactical (millions of short, subsecond queries), but there is an unknown factor, like unauthorized usage of the user ID, or a longer running component, that should be logged in a more detailed manner as to allow tuning or troubleshooting.