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 4 hours. The value specified 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. 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. Therefore, nothing is written to the SAS log.