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

Purpose  

Enables or disables logging in Summary Mode on most ResUsage tables.

Syntax  

 

Syntax element …

 

Is the …

tablename

name of the ResUsage table for which you want to enable or disable Summary Mode. Summary Mode for the tables is OFF by default.

Except for spma, sps, and ipma, you can enable or disable Summary Mode on the svpr, ivpr, scpu, sldv, spdsk, svdsk, sawt, and shst tables.

For details on how Summary Mode affects data reporting for these specific tables, see the table descriptions in Resource Usage Macros and Tables.

ON

enables Summary Mode on the ResUsage table specified.

OFF

disables Summary Mode on the ResUsage table specified.

Usage Notes  

Summary Mode is not applicable to the spma or ipma table because these ResUsage tables only report a single row of data for each node in normal mode.

Enabling Summary Mode reduces database I/O by consolidating and summarizing data on each system node.

To log summary rows for a table, the table must be enabled in the RSS Table Logging Enable group and the RSS Summary Mode Enable group. The corresponding Logging Rate (node or vproc) must be set to a nonzero value.

You can enable Summary Mode for individual tables in which great detail is not needed using the SET SUMLOGTABLE command. For more information on Summary Mode, see Resource Usage Macros and Tables.

You can also enable or disable logging in Summary Mode from the RSS screen of the Control GDO Editor (ctl) utility. For more information, see Chapter 7: “Control GDO Editor (ctl).”

To display the Summary Mode status of any ResUsage table, see “GET SUMLOGTABLE” on page 180.

Example  

The following example enables the sawt table to be logged in Summary Mode.

set sumlogtable sawt on