TENACITY= Data Set Option

Specifies how many hours that FASTEXPORT=, FastLoad, or MultiLoad continues to try to log on again to Teradata if the maximum number of Teradata utilities are already running.
Valid in: DATA and PROC steps (when creating and appending to DBMS tables using SAS/ACCESS software)
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, Using the TPT API

Syntax

TENACITY=number-of-hours

Syntax Description

number-of-hours
specifies the number of hours to continue to try again to log on to Teradata.

Details

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 the database server setting.) The default value for TENACITY= is four hours. The value specified for TENACITY= must be greater than zero.
Use TENACITY= with SLEEP=, which specifies the number of minutes that FASTEXPORT=, FastLoad, or MultiLoad waits before it retries logging on to Teradata. SLEEP= and TENACITY= function very much like the SLEEP and TENACITY run-time options of the native Teradata FastExport, FastLoad, or MultiLoad utility.
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 the FASTEXPORT=, FastLoad, or MultiLoad failure. SAS does not receive any informational messages from Teradata in either of these situations:
  • when the currently run FASTEXPORT=, FastLoad, or MultiLoad process waits because the maximum number of utilities are already running
  • if FASTEXPORT=, FastLoad, or MultiLoad is terminated because the time limit that TENACITY= specifies has been exceeded
The native Teradata FastExport, FastLoad, or MultiLoad utility sends messages associated with SLEEP= and TENACITY= only to the FastExport, FastLoad, or MultiLoad log. So nothing is written to the SAS log.