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

Returns the logging status on any ResUsage table.

Syntax

GET LOGTABLE { tablename | ALL }

Syntax Elements

tablename
name of the ResUsage table for which to display logging status. ResUsage table names are listed in the following table.
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.
For more information on these tables, see Teradata Vantage™ - Resource Usage Macros and Tables, B035-1099.
ALL
displays the logging status of all ResUsage tables.

Usage Notes

You can also view the logging status of the ResUsage tables by issuing the SCREEN RSS command in the Control GDO Editor (ctl) utility. For more information, see Control GDO Editor (ctl).

To enable or disable logging on any ResUsage table, see SET LOGTABLE.

Example: Displaying the current logging status for ResUsage tables

The following example displays the logging status of all ResUsage tables. The system displays a screen similar to this:

get logtable all

spma table's logging is disabled
ipma table's logging is disabled
svpr table's logging is disabled
ivpr table's logging is disabled
scpu table's logging is disabled
sldv table's logging is disabled
spdsk table's logging is disabled
svdsk table's logging is disabled
sawt table's logging is disabled
sps table's logging is disabled
shst table's logging is disabled
smhm table's logging is disabled