15.00 - FLUSH TRACE - Teradata Database

Teradata Database Utilities

Teradata Database
Release Number
Content Type
Publication ID
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 Chapter 14: “Gateway Control (gtwcontrol).”


Usage Notes  

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

For additional information, see “ENABLE TRACE” on page 658 and “DISABLE TRACE” on page 642.

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” on page 664.

For information on the gateway log files, see Chapter 14: “Gateway Control (gtwcontrol).”


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

flush trace