16.10 - GET ACTIVELOGTABLE - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

Shows the active row filtering status on any ResUsage table.

Syntax



tablename
name of the ResUsage table for which to show the active row filtering status.
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 affect on ResUsage tables, see Resource Usage Macros and Tables.

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