Purpose
Enables or disables logging in Summary Mode on most ResUsage tables.
Syntax
SET SUMLOGTABLE tablename { ON | OFF }
- 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.
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 Teradata Database. smhm Contains MAPS statistics. - 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 Teradata Vantage™ - Resource Usage Macros and Tables, B035-1099.
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 Control GDO Editor (ctl).
To display the Summary Mode status of any ResUsage table, see GET SUMLOGTABLE.
Example: Enabling summary mode logging for a ResUsage table
The following example enables the sawt table to be logged in Summary Mode.
set sumlogtable sawt on