17.10 - SET ACTIVELOGTABLE - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

Enables or disables active row filtering on any ResUsage table.

Syntax

SET ACTIVELOGTABLE { tablename | ALL } { ON | OFF }

Syntax Elements

tablename
name of the ResUsage table for which to enable or disable active row filtering.
ResUsage Table Name Description
spma Contains system-wide node information, intended primarily for Teradata engineers. This table is generally not used at customer sites.
ipma Contains system-wide node information, intended primarily for Teradata engineers. This table is generally not used at customer sites.
svpr Contains data specific to each virtual processor and its file system.
ivpr Contains system-wide virtual processor information, intended primarily for Teradata engineers. This table is generally not used at customer sites.
scpu Contains statistics on the CPUs within the nodes.
sldv Contains system-wide, storage device statistics.
spdsk Contains pdisk I/O, cylinder allocation, and migration statistics.
svdsk Contains statistics collected from the associated storage of the AMP.
sawt Contains data specific to the AMP worker tasks (AWTs).
sps Contains resource usage data about workloads.
shst Contains statistics on the host channels and LANs that communicate with Vantage.
smhm Contains MAPS statistics.
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 Teradata Vantage™ - Resource Usage Macros and Tables, B035-1099.

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