15.00 - SET LOGTABLE - 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

SET LOGTABLE

Purpose  

Enables or disables logging to any ResUsage table.

Syntax  

 

Syntax element …

Is the …

tablename

name of the ResUsage table for which to enable or disable logging.

  • spma: Contains the system-wide node information, which provides a summary of overall system utilization incorporating the essential information from most of the other tables.
  • 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 data by Performance Group (PG) ID.
  • shst: Contains statistics on the host channels and LANs that communicate with Teradata Database.
  • For more information on these tables, see Resource Usage Macros and Tables.

    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 Chapter 7: “Control GDO Editor (ctl).”

    To display whether logging to a ResUsage table is enabled or disabled, see “GET LOGTABLE” on page 176.

    Example  

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