16.10 - Mode Logging Option - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
April 2018
Content Type
Publication ID
English (United States)
Last Update

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 AM mP algorithm 3 (which includes data on aborted and parallel steps).

If you do not specify MODE, the algorithm is controlled by the DBS Control utility field DBQL CPU/IO Collection. For more information, see Utilities.

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