Mode Logging Option - Teradata VantageCloud Lake

Lake - Database Reference
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
ohi1683672393549.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
ohi1683672393549

The following option controls which CPU/IO collection algorithm Teradata uses for this query logging request.

Parameter Logging Behavior
MODE = m The CPU/IO collection algorithm to use for this query logging request, as specified by m. Possible values are:
  • 0 = Use the default value for this release (algorithm 1).
  • 1 = Use the classic algorithm 1 with step adjustments.
  • 2 = Use AMP algorithm 2 (diagnostic only).
  • 3 = Use AMP algorithm 3 (which includes data on aborted and parallel steps).

You must have the EXECUTE privilege on DBC.DBQLModeMacro to use this option.