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