16.10 - FLUSH TRACE - Teradata Database

Teradata Database Utilities

Teradata Database
Release Number
June 2017
English (United States)
Last Update


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