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

Purpose  

Returns the logging status on any ResUsage table.

Syntax  

 

Syntax element …

Is the …

tablename

name of the ResUsage table for which to display logging status.

  • spma: Contains the system-wide node information, which provides a summary of overall system utilization incorporating the essential information from most of the other tables.
  • 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 data by Performance Group (PG) ID.
  • shst: Contains statistics on the host channels and LANs that communicate with Teradata Database.
  • For more information on these tables, see Resource Usage Macros and Tables.

    ALL

    displays the logging status of all ResUsage tables.

    Usage Notes  

    You can also view the logging status of the ResUsage tables by issuing the SCREEN RSS command in the Control GDO Editor (ctl) utility. For more information, see Chapter 7: “Control GDO Editor (ctl).”

    To enable or disable logging on any ResUsage table, see “SET LOGTABLE” on page 194.

    Example  

    The following example displays the logging status of all ResUsage tables. The system displays a screen similar to this:

    get logtable all
     
    spma table's logging is disabled
    ipma table's logging is disabled
    svpr table's logging is disabled
    ivpr table's logging is disabled
    scpu table's logging is disabled
    sldv table's logging is disabled
    spdsk table's logging is disabled
    svdsk table's logging is disabled
    sawt table's logging is disabled
    sps table's logging is disabled
    shst table's logging is disabled