15.00 - GET ACTIVELOGTABLE - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

GET ACTIVELOGTABLE

Purpose  

Shows the active row filtering status on any ResUsage table.

Syntax  

 

Syntax element …

Specifies …

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” on page 255.

For information about active row filtering and its affect on ResUsage tables, see Resource Usage Macros and Tables.

Example  

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