Usage Note 13080: TENACITY data set option available for FastLoad in SAS® 9.1.3 of the SAS/ACCESS® Interface to Teradata
A new data set option, TENACITY, has been added to 9.1.3 of the
SAS/ACCESS Interface to Teradata. TENACITY specifies the time in hours
that SAS should keep on retrying to FastLoad data when the load
operation fails due to the maximum number of load operations already
running on the Teradata system. The default value for the option is 0
hours.
Syntax:
TENACITY=integer
where integer is a positive integer that represents the number of hours
that SAS keeps retrying the FastLoad operation.
Teradata has a limit on the number of load utilities that can be run
concurrently. The TENACITY parameter specifies how long SAS should
retry the FastLoad operation if it fails due to the maximum allowed load
operations already running on the Teradata system. The default time
after which the FastLoad is attempted is six minutes(this can be changed
by using the SLEEP= option. Please see SAS Note #013079 for more
information on the SLEEP option).
In the following example, if the FastLoading operation fails because the
maximum allowed load utilities are already running, SAS keeps retrying
the FastLoad operation every five minutes for the next two hours until
SAS is able to logon to the required number of sessions.
data mydblib.fastdata(fastload=yes sleep=5 tenacity=2);
set work.testdata;
run;
The following message will be displayed in the log every time the
FastLoad operation is attempted until SAS is able to logon to the
required number of sessions or the TENACITY time period expires.
Maximum number of Teradata utilities are running.
Fastload will be resubmitted in 5 minute(s).
If the same example were run without specifying the SLEEP and TENACITY
options, and the maximum number of load/unload utilities were already
running, the job fails with the following error message.
data mydblib(fastload=yes);
set work.testdata;
run;
ERROR: Fastload could not allocated data sessions. Too many
load/unload tasks running: try again later.
Operating System and Release Information
SAS System | SAS/ACCESS Interface to Teradata | Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | |
Microsoft Windows 2000 Professional | 9.1 TS1M3 | |
Microsoft Windows 2000 Server | 9.1 TS1M3 | |
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | |
z/OS | 9.1 TS1M3 | |
Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | |
64-bit Enabled Solaris | 9.1 TS1M3 | |
Microsoft Windows XP Professional | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | |
64-bit Enabled HP-UX | 9.1 TS1M3 | |
64-bit Enabled AIX | 9.1 TS1M3 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Usage Note |
Priority: | |
Topic: | SAS Reference ==> LIBNAME Engines Data Management ==> Data Sources ==> External Databases ==> Teradata
|
Date Modified: | 2004-08-18 16:58:54 |
Date Created: | 2004-08-16 15:33:57 |