Data Set Options for Relational Databases |
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 |
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.
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
TPT_MIN_SESSIONS= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.