15.00 - SET LOGTABLE - Teradata Database

Teradata Database Utilities

Teradata Database
Release Number
Content Type
Publication ID
English (United States)
Last Update



Enables or disables logging to any ResUsage table.



Syntax element …

Is the …


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.


    enables or disables logging on all ResUsage tables depending if the ON or OFF option is specified.


    enables logging on the ResUsage table specified.


    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.


    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.