16.10 - SET LOGTABLE - 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

Enables or disables logging to any ResUsage table.

Syntax



tablename
name of the ResUsage table for which to enable or disable logging. For a list of the ResUsage tables, see GET LOGTABLE
For more information on these tables, see Resource Usage Macros and Tables.
ALL
enables or disables logging on all ResUsage tables depending if the ON or OFF option is specified.
ON
enables logging on the ResUsage table specified.
OFF
disables logging on the ResUsage table specified.

Usage Notes

Before a table can be logged, the table must be enabled for logging and the corresponding Logging Rate must be set to a nonzero value.

You can also set logging from the RSS screen of the Control GDO editor (ctl) utility. For more information, see Control GDO Editor (ctl).

To display whether logging to a ResUsage table is enabled or disabled, see GET LOGTABLE.

Example: Enabling logging on all ResUsage Tables

In this example, logging is enabled on all the ResUsage tables on the current system.

set logtable all on

You can use the GET LOGTABLE command to display whether logging has been enabled on all ResUsage tables. For more information, see GET LOGTABLE.