Purpose
Returns the Summary Mode status of ResUsage tables.
Syntax
GET SUMLOGTABLE tablename
- tablename
- name of the ResUsage table for which to display the Summary Mode status.
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.
Usage Notes
You can display the Summary Mode status for all tables except spma and ipma because these ResUsage tables only report a single row of data for each node in normal mode.
For details on how summary mode affects data reporting for these specific tables, see the table descriptions in Teradata Vantage™ - Resource Usage Macros and Tables, B035-1099.
You can also view the status of ResUsage tables logged in Summary Mode from the RSS Screen of the Control GDO Editor (ctl) utility. For more information, see Control GDO Editor (ctl).
To enable or disable logging in Summary Mode on any ResUsage table, see SET SUMLOGTABLE.
Example: Displaying the Summary Mode status of ResUsage tables
The following example shows the Summary Mode status of the Svpr table.
get sumlogtable svpr svpr table's summary mode is disabled