SET LOGTABLE - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
xha1591998860283.ditamap
dita:ditavalPath
xha1591998860283.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantage™

Enables or disables logging to any ResUsage table.

Syntax

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

Syntax Elements

tablename
name of the ResUsage table for which to enable or disable logging.
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
enables or disables logging on all ResUsage tables depending if the ON or OFF option is specified.
ON
enables logging on the ResUsage table specified.
OFF
disables logging on the ResUsage table specified.

Usage Notes

Before a table can be logged, the table must be enabled for logging and the corresponding Logging Rate must be set to a nonzero value.

You can also set logging from the RSS screen of the Control GDO editor (ctl) utility. For more information, see Control GDO Editor (ctl).

To display whether logging to a ResUsage table is enabled or disabled, see GET LOGTABLE.

Example: Enabling logging on all ResUsage Tables

In this example, logging is enabled on all the ResUsage tables on the current system.

set logtable all on

You can use the GET LOGTABLE command to display whether logging has been enabled on all ResUsage tables. For more information, see GET LOGTABLE.