Mode Logging Option - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
English (United States)
Last Update
Product Category

Mode Logging Option

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



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).
  • 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.