FLUSH TRACE - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

Purpose

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).

Syntax

{ FLUSH | FL } { TRACE | TRAC }

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