Usage Note 13079: SLEEP data set option available for FastLoad in SAS® 9.1.3 of the SAS/ACCESS® Interface to Teradata
A new data set option, SLEEP, has been added to 9.1.3 of the SAS/ACCESS
Interface to Teradata. SLEEP specifies the time in minutes that SAS
should wait before re-attempting to FastLoad data when the load
operation fails due to the maximum allowed number of load operations
already running on the Teradata system. The default value for the
option is 6 minutes.
Syntax for the option is:
SLEEP=integer
where integer is a positive integer that represents the number of
minutes that SAS waits before retrying the FastLoad operation.
Teradata has a limit on the number of load utilities that can be run
concurrently. If a SAS FastLoad job is submitted when the limit has
been reached, the FastLoad job will fail. In such cases, specifying the
SLEEP parameter will cause SAS to retry the FastLoad operation after
sleeping for the specified time. Note that SLEEP will only retry the
FastLoad job only if it fails due to the maximum number of utilities
running. The TENACITY option specifies the number of hours FastLoad
should be retried and must be always specified with the SLEEP option.
This is because the default for TENACITY is 0 hours. Please refer to
SAS Note #013080 for more information on the TENACITY data set 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 everytime 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.fastdata(fastload=yes);
set work.testdata;
run;
ERROR: Fastload could not allocate 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: | Data Management ==> Data Sources ==> External Databases ==> Teradata SAS Reference ==> LIBNAME Engines
|
Date Modified: | 2004-08-18 16:56:23 |
Date Created: | 2004-08-16 15:10:00 |