Specifies the minimum 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: | 1 |
| 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_MIN_SESSIONS= data set option, 2. TPT_MIN_SESSIONS= LIBNAME option, 3. SAS_TPT_MIN_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= LIBNAME option, TPT_MAX_SESSIONS= data set option, TPT_MIN_SESSIONS= data set optionUsing the TPT API |
| Examples: | Set the SAS_TPT_MIN_SESSIONS environment variable
on PC hosts:
|
Set the SAS_TPT_MIN_SESSIONS environment variable
on UNIX hosts:
|
|
Set the SAS_TPT_MIN_SESSIONS environment variable
at SAS invocation:
|
Table of Contents
specifies the minimum 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 minimum value cannot be more than the value for the TPT_MAX_SESSIONS= LIBNAME option.