TD_TRACE_LEVEL= and TD_TRACE_LEVEL_INF= Table Options

Specifies the trace levels for driver tracing. TD_TRACE_LEVEL sets the primary trace level. TD_TRACE_LEVEL_INF sets the secondary trace level.

Category: Bulk Loading
Requirement: Must be specified within the BULKOPTS= Table Option
Data source: Teradata

Syntax

TD_TRACE_LEVEL= trace-level

Arguments

trace-level

specifies the type of diagnostic messages written by each instance of the driver to an external log file. The diagnostic trace function provides more detailed information (including the version number) in the log file to aid in problem tracking and diagnosis. The following trace levels are available:

TD_OFF disables driver tracing. TD_OFF is the default setting for both driver tracing and infrastructure tracing. No external log file is produced unless this default is changed. Specifying TD_OFF for both driver tracing and infrastructure tracing is the same as disabling tracing.
TD_OPER activates the tracing function for driver-specific activities. The absence of any value for the PauseAcq attribute means that the Update driver job executes both the acquisition phase and the application phase without pausing. This distributes all of the rows that were sent to the Teradata database during the acquisition phase to their final destination on the AMPs.
TD_OPER_CLI activates the tracing function for CLIv2-related activities (interaction with the Teradata database).
TD_OPER_NOTIFY activates the tracing function for activities related to the Notify feature.
TD_OPER_OPCOMMON activates the tracing function for activities involving the opcommon library.
TD_OPER_ALL activates the tracing function for all of the tracing activities.

Details

If the trace level is set to any value other than TD_OFF, an external log file is created for each instance of the driver.
The trace levels for infrastructure tracing should be used only when you are directed to by Teradata support. TD_OFF, which disables infrastructure tracing, should always be specified.

See Also

Table Options:
Last updated: February 23, 2017