Previous Page | Next Page

Data Set Options for Relational Databases

TPT_MAX_SESSIONS= Data Set Option



Specifies the maximum number of sessions for Teradata to use when using the TPT API with FastLoad, MultiLoad, or Multi-Statement insert.
Default value: 1 session per available Access Module Processor (AMP)
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support: Teradata

Syntax
Syntax Description
See Also

Syntax

TPT_MAX_SESSIONS=integer

Syntax Description

integer

specifies the maximum number of sessions for Teradata to use when using the TPT API to load data with FastLoad, MultiLoad, or Multi-Statement insert.

Details

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

You can control the number of sessions for Teradata to use when using the TPT API to load data with MultiLoad. The maximum value cannot be more than the number of available Access Module Processors (AMPs). 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_MIN_SESSIONS= Data Set Option

Previous Page | Next Page | Top of Page