FLUSH TRACE - Analytics Database - Teradata Vantage

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-05-02
dita:mapPath
ymn1628096214445.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantageā„¢

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