17.10 - FLUSH TRACE - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)

The gateway records all significant events to an internal circular buffer, such that as new events are recorded, older events are overwritten in the buffer. The FLUSH TRACE command directs the gateway to write every event currently in the buffer to the gateway log file. This preserves a record of the most recent events, which would otherwise be lost from the buffer.

FLUSH TRACE is useful for investigating gateway problems by logging the most recent gateway activities if tracing has not already been enabled with the ENABLE TRACE command, or with the Gateway Control tracing options. For more information on these options, see Gateway Control (gtwcontrol).



Usage Notes

The FLUSH TRACE command can be used when diagnosing gateway anomalies.

For additional information, see ENABLE TRACE and DISABLE TRACE.

Before using the FLUSH TRACE command, you must select the host group from which the session is running using the SELECT HOST command. For information, see SELECT HOST.

For information on the gateway log files, see Gateway Control (gtwcontrol).

Example: Writing buffered gateway events to the gateway log file

To direct the gateway to write the contents of its internal trace buffers to the gateway log file, type:

flush trace