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.

Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default:	1 session per available Access Module Processor (AMP)
Data source:	Teradata
See:	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

Syntax

Details

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.