Previous Page | Next Page

Data Set Options for Relational Databases

TPT_TRACE_LEVEL_INF= Data Set Option



Specifies the tracing level for the required infrastructure for sending data to Teradata and using the TPT API with Fastload, MultiLoad, or Multi-Statement insert.
Default value: 1
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support: Teradata

Syntax
Syntax Description
See Also

Syntax

TPT_TRACE_LEVEL_INF=integer

Syntax Description

integer

specifies the needed infrastructure tracing level (10 to 18) when loading data to Teradata.

10

no tracing

11

operator-level general trace

12

operator-level command-line interface (CLI) trace

13

operator-level notify method trace

14

operator-level common library trace

15

all operator-level traces

16

Telnet API (TELAPI) layer general trace

17

PutRow/GetRow trace

18

operator log message information

Details

To use this option, you must first set TPT=YES. This option is valid only when using the TPT API.

You can perform debugging by writing diagnostic messages to an external log file when loading data to Teradata using the TPT API. If you do not specify a name in TPT_TRACE_OUTPUT= for the log file, a default name is generated using the current timestamp. See your Teradata documentation for details.


See Also

Maximizing Teradata Load Performance

Using the TPT API

BULKLOAD= LIBNAME Option

BULKLOAD= Data Set Option

MULTILOAD= Data Set Option

MULTISTMT= Data Set Option

TPT= LIBNAME Option

TPT= Data Set Option

TPT_TRACE_LEVEL= Data Set Option

TPT_TRACE_OUTPUT= Data Set Option

Previous Page | Next Page | Top of Page