15.00 - SET ACTIVELOGTABLE - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

SET ACTIVELOGTABLE

Purpose  

Enables or disables active row filtering on any ResUsage table.

Syntax  

 

 

Syntax element …

Specifies …

tablename

name of the ResUsage table for which to enable or disable active row filtering.

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” on page 199.

To display the active row filtering status, see “GET ACTIVELOGTABLE” on page 169.

Example  

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

set activelogtable all on