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