16.10 - GET SUMLOGTABLE - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

Returns the Summary Mode status of ResUsage tables.

Syntax



tablename
name of the ResUsage table for which to display the Summary Mode status.

Usage Notes

Except for spma and ipma, you can display the Summary Mode status for the svpr, ivpr, scpu, sldv, spdsk, svdsk, sawt, sps, and shst tables.

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.

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

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