Specifies the maximum number of sessions for Teradata to use when using the TPT API with FastLoad, MultiLoad, or Multi-Statement insert.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Data Set Control |
| Default: | 4 |
| Restriction: | This option is valid only when using the TPT API. |
| Requirement: | To use this option, you must first specify TPT=YES. |
| Interaction: | [precedence] 1. TPT_MAX_SESSIONS= data set option, 2. TPT_MAX_SESSIONS= LIBNAME option, 3. SAS_TPT_MAX_SESSIONS environment variable, 4. the default value |
| Data source: | Teradata |
| Note: | Support for this LIBNAME option was added for SAS 9.4. |
| See: | BULKLOAD= LIBNAME option, BULKLOAD= data set option, Maximizing Teradata Load Performance, MULTILOAD= data set option, MULTISTMT= data set option, TPT= LIBNAME option, TPT= data set option, TPT_MAX_SESSIONS= data set option, TPT_MIN_SESSIONS= data set optionUsing the TPT API |
| Examples: | Set the SAS_TPT_MAX_SESSIONS environment variable
on PC hosts:
|
Set the SAS_TPT_MAX_SESSIONS environment variable
on UNIX hosts:
|
|
Set the SAS_TPT_MAX_SESSION environment variable at
SAS invocation:
|
Table of Contents
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.
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.