Generating the Teradata PT API Operator Log
TD_TRACE_LEVEL1 / TD_TRACE_LEVEL2
To generate the Teradata PT API operator log, you must set the following two environment variables:
If TD_TRACE_LEVEL1 or TD_TRACE_LEVEL2 is not set, the Teradata PT API operator log is not generated.
The possible values for TD_TRACE_LEVEL1 and TD_TRACE_LEVEL2 are listed in the schema.h file.
The best value for:
These values generate a complete Teradata PT API operator log.
TD_TRACE_OUTPUT
Setting the following environment variable TD_TRACE_OUTPUT is optional.
TD_TRACE_LOGSQL
Setting the following environment variable TD_LOGSQL is optional.
If this variable is not set, the variable takes the default value, which is No.
Valid values:
Note: If both the environment variables and the attributes in the application are set simultaneously, the values from environment variables are considered. The environment variables have high precedence over the attribute values.
Example
If:
the Teradata PT API operator log is generated in a newly created file named according to the value to which TD_TRACE_OUTPUT is set.
Example
If:
the Teradata PT API operator log is generated in a newly-created file that Teradata PT API names.
Example
If:
and the above values are not set in the application as attributes,
the TPTAPI operator log is not generated.
Example
If:
and the above values are not set in the application as attributes,
the TPTAPI operator log is not generated.