15.00 - GET 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

GET SUMLOGTABLE

Purpose  

Returns the Summary Mode status of ResUsage tables.

Syntax  

 

Syntax element …

Is the …

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 Chapter 7: “Control GDO Editor (ctl).”

To enable or disable logging in Summary Mode on any ResUsage table, see
“SET SUMLOGTABLE” on page 199.

Example  

The following example shows the Summary Mode status of the Svpr table.

get sumlogtable svpr
 
svpr table's summary mode is disabled