Specifies how many hours to attempt to acquire a Teradata utility slot if the maximum number of Teradata utilities are already running.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Data Set Control |
| Default: | 0 (FastLoad) |
| 4 (FastExport, MultiLoad) | |
| Data source: | Teradata |
| Tip: | The data set option has precedence over the LIBNAME option. |
| See: | DBSLICEPARM= LIBNAME option, DBSLICEPARM= data set option, DBSLICEPARM= system option, FASTEXPORT= LIBNAME option, Maximizing Teradata Load Performance, MULTILOAD= data set option, SLEEP= LIBNAME option, SLEEP= data set option, TENACITY= data set option, Using the TPT API |
Table of Contents
specifies the number of hours to continue to attempt to acquire a Teradata utility slot.
Use this option to indicate to FastExport, FastLoad, or MultiLoad how long to continue retrying a logon operation when the maximum number of utilities are already running. (The maximum number of Teradata utilities that can run concurrently varies from 5 to 15, depending on database settings.) The default value for TENACITY= is 4 hours. The value that you specify for TENACITY= must be greater than zero.
Use TENACITY= with SLEEP=. SLEEP= specifies the number of minutes that FastExport, FastLoad, or MultiLoad waits before it retries logging on to Teradata.
Here is an example of the message that is written to the SAS log if the time period that TENACITY= specifies is exceeded.
ERROR: MultiLoad failed unexpectedly with returncode 12
Check the FastExport, FastLoad, or MultiLoad log for more information about the cause of a failure. SAS does not receive any informational messages from Teradata in either of these situations: