17.10 - GET 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)

Shows the active row filtering status on any ResUsage table.

Syntax

GET ACTIVELOGTABLE { tablename | ALL }

Syntax Elements

tablename
name of the ResUsage table for which to show the active row filtering status.
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
the active row filtering status of all ResUsage tables on the system.

Usage Notes

To enable or disable active row filtering, see SET ACTIVELOGTABLE.

For information about active row filtering and its effect on ResUsage tables, see Teradata Vantage™ - Resource Usage Macros and Tables, B035-1099.

Example: Showing the active row filtering status for ResUsage tables

The following example shows the active row filtering status of all ResUsage tables on the current system. The system displays a screen similar to this:

get activelogtable all

spma table's active row filtering mode is disabled
ipma table's active row filtering mode is disabled
svpr table's active row filtering mode is disabled
ivpr table's active row filtering mode is disabled
scpu table's active row filtering mode is disabled
sldv table's active row filtering mode is disabled
spdsk table's active row filtering mode is disabled
svdsk table's active row filtering mode is disabled
sawt table's active row filtering mode is disabled
sps table's active row filtering mode is enabled
shst table's active row filtering mode is disabled
smhm table's active row filtering mode is disabled