16.10 - SET LOGTABLE - Teradata Database

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.