16.10 - SET ACTIVELOGTABLE - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

Enables or disables active row filtering on any ResUsage table.

Syntax



tablename
name of the ResUsage table for which to enable or disable active row filtering. For a list of the ResUsage tables, see GET LOGTABLE
ALL
enables or disables active row filtering on all ResUsage tables depending if the ON or OFF option is specified.
ON
enables active row filtering on any one of the ResUsage tables specified.
OFF
disables active row filtering on any one of the ResUsage tables specified.

Usage Notes

Active row filtering mode reduces the number of data rows that are logged to the database. For the tables for which this option is ON (enabled), only those rows whose data has been modified during the current logging period will be logged.

For some ResUsage tables, like sps, there are a large number of possible rows, and most of them are not used at any one time. Logging the inactive rows would waste a large amount of resources. Therefore, Teradata recommends that Active Row Filter Mode remain enabled for these tables.

To log rows, the tables that are enabled for Active Row Filter Mode must also have the table selected for logging and a corresponding Logging Rate of nonzero.

To learn more about active row filtering, see Resource Usage Macros and Tables.

For information on Summary Mode, see SET SUMLOGTABLE.

To display the active row filtering status, see GET ACTIVELOGTABLE.

Example: Enabling active row filtering for all ResUsage tables

The following example enables active row filtering on all ResUsage tables.

set activelogtable all on