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) |
|---|---|
| Category: | Bulk Loading |
| 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: | The default value was changed to 4 for SAS 9.4. |
| See: | BULKLOAD= LIBNAME option, BULKLOAD= data set option, MULTILOAD= data set option, MULTISTMT= data set option, TPT= LIBNAME option, TPT= data set option, TPT_MAX_SESSIONS= LIBNAME option, TPT_MIN_SESSIONS= data set option, |
| Maximizing Teradata Load and Read Performance, Using the TPT API |
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.